Macros that solicit user input data

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

Guest

Is there a way to solicit data from the user during a macro run? For example, can I set it up so that each time I run the macro, I can input a particular number, e.g., "input the number of participants"..
 
Use an InputBox

Regards

Trevor


CC said:
Is there a way to solicit data from the user during a macro run? For
Click to expand...
example, can I set it up so that each time I run the macro, I can input a
particular number, e.g., "input the number of participants"..
 
CC

Num = InputBox("Enter number of participants")
ActiveCell.Value = Num
MsgBox "Number of participants is " & Num

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

automatic date entry in XL cell.. 3
Input box to find date 4
using excel vba ope a word doc and copy-paste into another word doc 0
Enabling Macro with the worksheet file 2
Best way to solicit input then run a macro? 4
Dynamic Excel data into locked Word form 0
Access - automatically add email extensions 0
Macro to copy value in field and insert it into filter 2

Back
Top