If you use the Application.InputBox you can specify the type of
value to return. Setting type:=8 allows the user to enter (or
select, using the GUI) a cell reference. For example:

Dim rng As Range
Set rng = Application.InputBox( _
Prompt:="Enter or select range:" & vbNewLine, _
Title:="Enter Range", _
Type:=8)
Application.Goto rng(1)




In article ,
"TBA" wrote:

How do I use the value a user enters in an Input Box as a variable? What
I'd like to do is use an Input Box where the user enters in the cell address
of the top-left cell in the table they wish to work with. For example they
might type in A1 or B3, etc. Then I want to be able to select that cell
based on what the user types. Can it only be a string value? Any tips
appreciated. Thanks!

-gk-