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

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

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

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