| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Show worksheet from cmd button on userform
Hi,
I have a userform with a series of buttons. I want the user to be able to click a button and the system will bring the 'Input Log' sheet into focus. ideas? -- Carlee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Show worksheet from cmd button on userform
'into focus' Do you mean Select or Preview?
"Carlee" wrote in message ... Hi, I have a userform with a series of buttons. I want the user to be able to click a button and the system will bring the 'Input Log' sheet into focus. ideas? -- Carlee |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Show worksheet from cmd button on userform
Select:
userform1.hide <=== Or what ever your Userform number is. sheets("Input Log").select Preview: userform1.hide <=== Or what ever your Userform number is. with sheets("Input Log") ..select ActiveWindow.SelectedSheets.PrintPreview end with userform1.show Corey.... "Carlee" wrote in message ... Hi, I have a userform with a series of buttons. I want the user to be able to click a button and the system will bring the 'Input Log' sheet into focus. ideas? -- Carlee |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Show worksheet from cmd button on userform
Hi,
Did you mean select sheet, you can select sheet by code like: Sub CommandButton1_Click() Sheets("Input Log").Select End Sub -- Regards, Halim "Carlee" wrote: Hi, I have a userform with a series of buttons. I want the user to be able to click a button and the system will bring the 'Input Log' sheet into focus. ideas? -- Carlee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Command Button to show/hide a different worksheet | Excel Discussion (Misc queries) | |||
| Worksheet protected-auto filter works, show all button dosen't. | Excel Discussion (Misc queries) | |||
| "Show all" button not work in protected worksheet | Excel Worksheet Functions | |||
| Specifying a Command Button on a worksheet as differentiated from one on a UserForm | Excel Programming | |||
| Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Linear Mode
