Selecting a Worksheet

[Rocky0201]

Hi...

In my worksheet (we'll call it Sheet1) I have a BeforeDoubleClick that launches Userform1.

UserForm1 has a ComboBox and a TextBox where the user can select a predefined list of names (The name in the TextBox is the name of another worksheet).

Also on the UserForm1 I have a CommandButton that I call Go To. My goal is to go to the worksheet that has been select from the ComboBox when the CommandButton is pressed.

As I step through the code, the worksheet I want to go to is in fact selected but then the Sheet1 is immediately re-selected when I return back to Sheet1.

How do I go to Sheet2 from Sheet1 and stay on Sheet2?

Thanks for the help.

 

[Norie]

If it's the combobox with the worksheet names you could try this.

Application.Goto Worksheets(ComboBox1.Value).Range("A1"), True

I'm not actually sure where the textbox comes into it though.

 

[Rocky0201]

Absolutely wonderful, Norie!!!! thank you so much...