| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I program for a 'generic' worksheet to open
I am trying to write a program in excel visual basics. My progam has
numerous worksheets and I would like the user to input from an inputfunction box the worksheet to access and then have the program open and display that worksheet. ie Dim Message, MyValue Message = "Enter a sheet name" ' Set prompt. MyValue = InputBox(Message, Title, Default) Worksheets(MyValue).Visible = True I want the user's input to open a worksheet with that name. any help would be most welcome. thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do I program for a 'generic' worksheet to open
close --
use select not visible ... Dim Message, MyValue Message = "Enter a sheet name" ' Set prompt. MyValue = InputBox(Message, Title, Default) Worksheets(MyValue).Select -----Original Message----- I am trying to write a program in excel visual basics. My progam has numerous worksheets and I would like the user to input from an inputfunction box the worksheet to access and then have the program open and display that worksheet. ie Dim Message, MyValue Message = "Enter a sheet name" ' Set prompt. MyValue = InputBox(Message, Title, Default) Worksheets(MyValue).Visible = True I want the user's input to open a worksheet with that name. any help would be most welcome. thanks . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
| Generic Worksheet Names | Excel Discussion (Misc queries) | |||
| Open Outlook with generic message | Excel Discussion (Misc queries) | |||
| I cant open files unless I open the Excel program first | Excel Discussion (Misc queries) | |||
| how do i open Excel program without loading a new worksheet? | Excel Discussion (Misc queries) | |||
Hybrid Mode
