| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
lotus uses {?} for input, what does excel use (macros)
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
lotus uses {?} for input, what does excel use (macros)
Here are 2 methods
Reply = MsgBox(Prompt:="Tell me what to do", Buttons:=vbYesNoCancel, Title:="Give me info") Namestring = InputBox(Prompt:="You name please.", Title:="Enter Name", Default:="Name Please") Mike "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? |
|
#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? |
| Reply |
| 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) | |||
Linear Mode
