Macro Combobox for WS and selection takes you to sheet

[jaredmccullough]

I am looking for a macro to populate a combobox with the WS name of all worksheets in the workbook except "Sheet1, Sheet2, Sheet3". Then when the user selects the choice from the combobox it takes them to that worksheet.

[zbor]

Why not just right click on arrows in lower left corner and choose sheet you like?
Untitled.png

[zbor]

But here, try this with userform:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[jaredmccullough]

zbor,

Thanks for the reply. I forgot to mention this is not a userform combobox. How I have it initating is through a "Shape" "Click" Command and then a ComboBox1 on a Worksheet. The following is the adjusted code I have applied:
Shape Code:

Please Login or Register  to view this content.

ComboBox on WS Code:

Please Login or Register  to view this content.

I have run into a problem though the combobox for some reason has populated multiple results of the same WS. I as well would like the combobox to reset after a selection has been made so that the user has to hit the "Shape Click" again to activate it. Attached is the workbook if you look at the first 3 Worksheets they have the same dashboard. The Shape "Go To Audit" initiates the combobox. Could you happen to take a look and point me in the right direction.

(PSM-14-02) PSAudit.xlsm

[jaredmccullough]

See the first attachment. (i.e. not the 153.8 KB attachment for some reason this loaded too and I cant get it off)

[jaredmccullough]

But here, try this with userform:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

zbor,

I forgot to quote the last comment you made and was wondering if you happened to see my last post?

[zbor]

You already have 10 userforms. One more or less won't hurt And you can put that clicking on the shape you run userform.

[jaredmccullough]

I have the comboboxs already designed into my dashboard though lol