Macros that solicit user input data

C

CC

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"..
 
T

Trevor Shuttleworth

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"..
 
G

Gord Dibben

CC

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

Gord Dibben Excel MVP
 
Top