Using Userform to switch between worksheets

[hernandj]

Is it possible to use a VBA user form to switch between worksheets. I would like to use a VBA userform as a menu selector. The user would make a selection from a list box and a sheet would be opened. When that sheet is closed, the list box would be displayed for the next worksheet selection.

Can this be done? If so, is there an example available?

Thanks in advance for your help.

 

[javles]

@Trebor76
i think the idea is to hide the tabs and make a pretty menu page...?

Hello diddi,
I'm working on an admin system and the idea is to hide the tabs and make a menu page.
I'm using Excel 2007. What would be the code to hide the tabs and get a non-excel look?

Thanks in advance.

 

[diddi]

hi javles and welcome to the board.
the best way to remove the excel look and make your own apps is to use all your own userforms to interact with the user.
once your project is to that stage, then hide excel

 

[javles]

Thanks for your reply!

My userform is ready and added some command buttons to switch between worksheets.
The code for the buttons is the one I found in this thread

Private Sub CommandButton1_Click()
Sheets("List").Select
End Sub

I'm getting this error when I hit run and click the button,
Run-time error 9:
Subscript out of range

 

[Trebor76]

Hi javles,

List must not be the exact name of the tab. Check for leading or trailing spaces and try again.

Robert

 

[diddi]

if you want to remove the excel look, you cannot design the forms on sheets. do you know how to create a userform?

 

[javles]

Ï was able to resolve it. Thanks for your help @diddi.

The correct code was:

Sheets(1).Select

And I did create a userform. Everything is working fine.