user input in macros

  • Thread starter donna culberson
  • 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?
 
D

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
 
D

Danny

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

Danny

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

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

Top