Request input from user and store as variable

[alyssa75]

I used to know this but am drawing a blank

I want to request input from the user using a message box...something like this:

What is your name?

They type Tim
and that is stored as myUserName

Thanks!

 

[Marcelo Branco]

Hi,

Something like

Sub getName()
    Dim userName As String
 
    userName = Application.InputBox(Prompt:="What is your name?", Title:="UserName", Type:=2)
    MsgBox userName
End Sub

HTH

M.

 

[meldoc]

Hello

Try.

<font face=Courier New><SPAN style="color:#00007F">Sub</SPAN> test()<br><SPAN style="color:#00007F">Dim</SPAN> myUserName <SPAN style="color:#00007F">As</SPAN> <SPAN style="color:#00007F">String</SPAN><br>  myUserName = InputBox(Prompt:="What is your name?", Title:="Name")<br>  MsgBox myUserName<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[alyssa75]

Thanks!