Populate Excel Userform with Sheet names with double click to open the sheet ??

[Shacker]

I found this code here , and its great one

Please Login or Register  to view this content.

now how to add double click on the sheet in the list box and open this sheet ???
any Idea's ??
or is it possible ?

[AndyLitch]

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[Shacker]

Norie,
Thank you so much ..
I tried your code it gave me Tun Time error '1004': method 'Goto' of object '_Application Failed'

AndyLitch,
Thank you too for your reply , but the code didn't do anything ..

any suggestions ?

[Norie]

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Shacker]

this is a demo for the code

test55.xlsm

[Norie]

You've called the userform WorkSheets, why?

Worksheets is an object in VBA, it represents a collection of the worksheets in the workbook.

Try changing the form name to something else, eg frmWorksheets.

[Shacker]

I name it now frmWorksheets
same error

[Norie]

That's really weird because I did exactly that and I don't get any errors.

[Shacker]

lol, seems something wrong with my excel version

Strange ...
I even restart my machine .. still the same error


thank you for your help and support Norie

[Norie]

Can you upload the updated workbook?

[Shacker]

I know where is the problem !!!
its coz I am HIDING my sheets ....
but I need them to be hidden


test55.xlsm

[Norie]

2 options.

1 Don't add hidden sheets to the listbox.

2 Don't try and goto hidden sheets.

First option is probably best.

Please Login or Register  to view this content.

[Shacker]

I solve it by making a login form with all sheets to come Visible when login pass
and all sheets to be hidden when logout from the workbook


I guess it will solve this problem

Thank you for your big SUPPORT Norie