Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using record macro, can I stop it to get user input?
If I am creating a macro using the macro recorder and not entering lines
using VBA can the process be stoped to allow a user to input information? Like text, numbers or cell references? Thanks CeeDee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using record macro, can I stop it to get user input?
hi
the recorder records your actions on the keyboard and mouse only. if you want your users to have the ablility to input data, you would have to do some editing of the recorded macro afterwards to add an inputbox. dim str as string str = inputbox("Enter something") if you are unfimilar with the inputbox, read up on it in vb help. regards FSt1 "CeeDee" wrote: If I am creating a macro using the macro recorder and not entering lines using VBA can the process be stoped to allow a user to input information? Like text, numbers or cell references? Thanks CeeDee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Record the time a user selects a macro | Excel Programming | |||
Macro to record user name and date/time | Excel Discussion (Misc queries) | |||
Macro Record Stop Button | Excel Discussion (Misc queries) | |||
Finding a record based on user input | Excel Discussion (Misc queries) | |||
Record Macro - Record custom user actions | Excel Programming |