TextBox and InputBox

[Dennis Chou]

How can I get a textbox to display the range selected in an input box?

for example, if the user selects range a1 in an inputbox, i'd like the
textbox to display the range "=a1"

 

[Rick Rothstein]

I'm guessing you used the Application InputBox with a type=8 in order to
return a range object. Since it is a range that is returned, you can just
specify its address and concatenate the equal sign to the front of it...

TextBox1.Value = "=" & Application.InputBox("What is the range?", _
"Get Range", , , , , , 8).Address

 

[Dennis Chou]

Thanks, that worked

I'm guessing you used the Application InputBox with a type=8 in order to
return a range object. Since it is a range that is returned, you can just
specify its address and concatenate the equal sign to the front of it...

TextBox1.Value = "=" & Application.InputBox("What is the range?", _
"Get Range", , , , , , 8).Address