lotus uses {?} for input, what does excel use (macros)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jmoore - 31 Dec 2007 02:17 GMT

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 to this Message

Mike H - 31 Dec 2007 08:31 GMT

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

> 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 to this Message

Gord Dibben - 31 Dec 2007 23:48 GMT

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

>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 to this Message

Rate this thread: