Terrin,

For the input declare a variable
Dim myvar
set it "as String" but be ready to trap any errors.

Keep in mind that any InputBox will return a String even
if the user enters a number.

Than
myvar = InputBox("Prompt", "Title", "Default", xpos, ypos)
Prompt should be your instruction
Title should be what ever you want to call it
Default can be nothing, a given string, or another variable

than
MsgBox("My state is " & myvar)

see if this helps...
--
sb
"Terrin" wrote in message
om...
Hello,
I am currently creating a spreadsheet to automate a few tasks for
my users. Currently I have a command button in place, when this is
clicked, a msgbox pops up and asks for user input. What I need to
happen is the user input to be declared as a variable. Once it is
declared, probably with IF statements, I need to reference a msgbox,
depending on what the user inputs, I need to direct to the
corresponding msgbox. Example, the user inputs the two-letter
abbreviation for a state. Using that abbrev, I need to return a msgbox
with the corresponding text.

Any ideas as to how I can do this? If you could get me started with
the code, or point me in the direction that would be great.

For more explanation e-mail .
Thanks.