Macro Examples for prompting info

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for a good source of examples to show an Excel macro that
prompts for input, then finishes executing macro using the input. Any books,
online sites, or personal inventory would help. Thanks.
 
Sub sonic()
n = Application.InputBox("give me a number:", 1)
MsgBox ("you gave me: " & n)
End Sub
 
Back
Top