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? |
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? |
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? |
All times are GMT +1. The time now is 11:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com