user input in macros

  • Thread starter Thread starter donna culberson
  • Start date Start date
D

donna culberson

How do I create a macro with a prompt inserted to force
the user to enter input then resume the macro once the
user input has been entered?
 
Donna,

I'm not sure how much you know about macros, so I'll
give you the link to David McRitchies Site (Section about
getting started with macros)
http://www.mvps.org/dmcritchie/excel/getstarted.htm

After a little bit of learning (if you don't already know a
lot) the following will prompt a user for input...

myVariable = InputBox("Enter a Value")

Dan E
 
At which point (EVENT) would you like the prompt/message
box to appear, before save, before close, before print or
what event?
 
Back
Top