Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Waiting for Input in a macro
In a macro I am running, the cursor is required to select a cell 'E1',
where the user is expected to enter some value and once the value is entered, the macro should execute the remaining lines. However, I am unable to cause the macro to wait till the input is actually entered and the macro executes all the lines without waiting for input. Can someone suggest a solution ? Range("E1").Select ActiveCell.FormulaR1C1 = "" ActiveSheet.PageSetup.PrintArea = "$A$1:$I$51" ActiveWorkbook.Save ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Waiting for Input in a macro
Call up an InputBox to get the needed value. Put that value back into
cell E1 if needed. Look up "inputbox" in VBA Help for more information. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Editing a simple macro | Excel Worksheet Functions | |||
Can T Get Macro To Run! | New Users to Excel | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) |