Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pausing a macro for user input
What is the command to pause a macro so user can input a
line number that changes with each use of the spreadsheet. Old Lotus command was {?} |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pausing a macro for user input
Wayne,
Try this: Dim x As Long x = InputBox("What line?", "") Rows(x).Select -- sb "Wayne" wrote in message ... What is the command to pause a macro so user can input a line number that changes with each use of the spreadsheet. Old Lotus command was {?} |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need macro to post data from user input | Excel Worksheet Functions | |||
pausing a macro to input cell contents | New Users to Excel | |||
Macro for user to input 10 numbers | New Users to Excel | |||
Spreadsheet pausing,calculating cells,up2 100%,each input,why? | Excel Discussion (Misc queries) | |||
Can a macro be suspended during user input? | Excel Programming |