Macro Examples for prompting info

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for a good source of examples to show an Excel macro that
prompts for input, then finishes executing macro using the input. Any books,
online sites, or personal inventory would help. Thanks.
 
Sub sonic()
n = Application.InputBox("give me a number:", 1)
MsgBox ("you gave me: " & n)
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run code from another workbook 7
need help w/ macro prompting with info and pasting the info based on user input 8
Excel Macro Prompting 2
Date Entry through input prompt 9
Macro prompts for a number to be used in this macro as a variable 6
Prompt User to Select Macro to Run? 1
Macro for automatically moving to next column or row 1
Macro to complete Google search based on a cell? 0

Back
Top