| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
lotus uses {?} for input, what does excel use (macros)
Check out VBA help on InputBox
examples............. to pause for user entry whatname = InputBox("Enter a Name") to pause for range selection Set rngCopyTo = Application.InputBox( _ prompt:="Select the Destination Cell", _ Title:="Copy Range Formulae", Type:=8).Cells(1, 1) Gord Dibben MS Excel MVP On Sun, 30 Dec 2007 18:17:00 -0800, jmoore wrote: i can't figure out how to get the macro to stop for the input. what is the designation in the macro to wait for user input? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lotus to Excel to Lotus | Excel Discussion (Misc queries) | |||
| Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions | |||
| Excel to Lotus | Excel Discussion (Misc queries) | |||
| troubleshooting exporting Lotus 123 files with macros to Excel 200 | Excel Discussion (Misc queries) | |||
| Lotus Macros do not convert to Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
