VBA to navigate to a sheet selected from a drop down list

**cobwebs** · 01-29-2016, 11:06 AM

I have a User Form with a drop down list of sheets. I want to select a sheet name from the list and navigate to that sheet
Any and all help would be appreciated
I've tried the code below but obviously this doesn't work

Case "Pivot Tables"
Application.ScreenUpdating = False

Sheets("Tables").Visible = True
ActiveWindow.SelectedSheets.Visible = False

Sheets("Tables").Select
Range("A5").Select

'Clear all cells
Cells.Select
Range("D1").Activate
Selection.ClearContents
Range("A1").Select
Application.ScreenUpdating = True

regards

Cobwebs

**Johann Kovalenko** · 01-29-2016, 04:49 PM

When it comes to only activating a sheet, this code might help:

Private Sub UserForm_Activate()

list_box.AddItem "Sheet1"
list_box.AddItem "Sheet2"

End Sub

Private Sub CommandButton1_Click()
sheet_name = list_box.Value
Worksheets(sheet_name).Activate
End Sub

VBA to navigate to a sheet selected from a drop down list

LinkBack

Thread Tools

Rate This Thread

Display

VBA to navigate to a sheet selected from a drop down list

Re: VBA to navigate to a sheet selected from a drop down list

Thread Information

Users Browsing this Thread

Similar Threads

Drop down list that changes selected sheet

Total a cell starting from first sheet upto the sheet name selected from drop-down list

HELP : Unhide sheet only the Selected option from drop down list

Navigate in a drop down list

Extract data from sheet selected from drop down list

Value selected on drop down list, look-up on different sheet

Can I use a drop down list to navigate to other spreadsheets

Bookmarks

Bookmarks

Posting Permissions