picking an item from listbox to go to another WS

[aydinaks]

Hello,


I hope everything is great for you. I need your urgent help please.
I created a listbox on a worksheet. I would like to go to specific worksheet which I linked, when I select an item from the listbox and click a button that I created on the same ws.
I've found that code below from forum but it doesnt inlude the button code. Also I would like to hide all the WS' if it is possible ? Please help me. Thank you in advance.

Please Login or Register  to view this content.

Briefly : when I pick AA and click to Button, I would like to go to AA WS.

Best Regards,

[arlu1201]

Can you please upload a sample of the file you are using?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[aydinaks]

I've added the sample file.Thank you.

[nathansav]

You would put similar code in the button_click event for your button

like

Please Login or Register  to view this content.

[aydinaks]

Hello,

Unfortunately it doesnt work. Now I have a Run time error:438 Object doesnt support this property or method

[Andy Pope]

Please Login or Register  to view this content.

[aydinaks]

Dear Andy,

You and all the forum friends are great ! Thank you very much. Here is my last question. Is it possible to add this code to the main code (yours) to hide the sheet ?
If so, could you please help me ? Thank you in advance.

Please Login or Register  to view this content.

[aydinaks]

I've solved all the problem.Thank you very much for all.

All the Best,