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

J

jmoore

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?
 
M

Mike H

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Macro Security 1
Macro warning in word 1
VBA word change keys 0
Cell data entering slow! 0
Macro to select and delete levels of a document 2
Word macro that can call cells out of Excel for a find and replace 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0

Top