Question about Input Box and how to use the entered value

Posted to microsoft.public.excel.programming

TBA[_2_]

external usenet poster

Posts: 58

Question about Input Box and how to use the entered value

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-

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Avoiding error on Input Box - if no value is entered	dhstein	Excel Discussion (Misc queries)	5	April 25th 09 12:43 PM
Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet	Doctorjones_md	Excel Discussion (Misc queries)	3	June 27th 07 04:14 PM
Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet	Doctorjones_md	Excel Worksheet Functions	3	June 27th 07 04:14 PM
Input Date when data is entered into another cell	GaryByrd	Excel Worksheet Functions	2	February 1st 05 12:37 AM
Input box question	losmac	Excel Programming	0	August 20th 03 10:32 PM

All times are GMT +1. The time now is 11:51 AM.

Menu

About Us