-
Okay, I am working with an excel document and I have an input box coming up asking for a range, I have the string for selecting the range, but I need that put in to a variable, what kind of variable does it need to be? Nothing seems to work! Please help.
Thanks in advance
-
The easiest way to get the code you need is to turn macros on (in Excel), select the range, turn macros off and cut-n-paste the macro code into VB
-
This is within an Excel spreadsheet.
-
I'm sort of confused on what you want, but here is my attempt.
Dim sResp as string
sResp = input("Please enter a range.", "Enter Range")
Now the response is in string format.
Is that what you wanted?