Get User Input
 

Philip

Public Sub who_is_it()
Dim somename as String
somename = InputBox("Enter your name")
MsgBox "your name is " & somename
End Sub

Gord Dibben Excel MVP - XL97 SR2 & XL2002


On Wed, 23 Jul 2003 09:12:37 -0700, "Philip Perez"
wrote:

Is there a way to get a user's input while executing a
macro in Excel? I would like to have the user who is
running the macro enter a string or number, and then store
their response in a variable declared within the macro.