Hyperlink from drop down list

Dears,

I have a drop down list. I want to make a hyper link to each sheet in my workbook from the drop dwon list. for ex:

The lsit as follow: Sheet 1
Sheet 2
Sheet 3

When i choose sheet 1 automatically direct me to sheet 1

No need for a macro. This is standard Excel functionality.

Right click on the arrow buttons to the left of the sheet tabs. This will bring up a list of the sheets in your workbook. Click on a sheet name and that sheet will be activated.

Again: No need for a macro or duplicating Excel functionality in a drop-down list.

Kindly right-click the arrow buttons to the left of the sheet tabs and click the desired sheet.

There is no need to re-invent the wheel and jump through hoops to re-create native Excel functionality. Just five minutes of user education will do.

cheers,

If you want to do this with code, then you could use

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("D3")) Is Nothing Then
    Sheets(Range("D3").Text).Activate
End If

End Sub

but then again, in your attached file, the spelling of the sheet names is wrong. Your list shows "Sheet 1", whereas the actual sheet name is "Sheet1", so if you don't take care to that kind of detail, you'd be much better off with the right-click on the arrow buttons to the left of the sheet tab. There you will always find the correct spelling of the existing sheet names.

Details are important!

So, does the code posted above solve your issue?