Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompt user for input and utilize that input | Excel Worksheet Functions | |||
Looking for help with user input variable€¦ | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
Sort Without User Input | Excel Discussion (Misc queries) | |||
Get User Input | Excel Programming |