View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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?