ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Storing User response (https://www.excelbanter.com/excel-programming/363169-storing-user-response.html)

Marco

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

Thank you.

Marco

Chip Pearson

Storing User response
 
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" wrote in message
...
I need a code that will store a user response to use later in
the macro.

Thank you.

Marco





All times are GMT +1. The time now is 09:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com