user input in macros

[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?

 

[Dan E]

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

 

[Danny]

At which EVENT do you want the prompt? Before save, before
close or before print?

 

[Danny]

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