Storing User response

[Marco]

I need a code that will store a user response to use later in the macro.

Thank you.

Marco

[Chip Pearson]

Just store the user's response in a variable.


Dim Resp As Variant
Resp = InputBox("Enter something")
'
' more code
'
MsgBox Resp




--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Marco" <[email protected]> wrote in message
news:[email protected]...
>I need a code that will store a user response to use later in
>the macro.
>
> Thank you.
>
> Marco