Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
InputBox to capture user selected sheet names?
I am using Office 2003 on Windows XP.
Rather than going thru the hassle of designing and coding a userform for this purpose, I would like to know if it is possible to just use a regular "InputBox" in the following manner: After display, allow the user to click on various sheet tabs and have the sheet tab names captured and returned in a string variable in the code. 1) Can this be done? 2) Could you please post example code that would function in this way? Thanks much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capture user ID... | Excel Discussion (Misc queries) | |||
Macro to capture worksheet names | Excel Worksheet Functions | |||
Array of all selected sheet names? | Excel Programming | |||
get all sheet names in comboBox of activeworkbook and export when selected | Excel Programming | |||
Inputbox used to return value of selected cell | Excel Programming |