Activate Sheet by selecting Cell Value

Hello,

I have some code that creates a list of all my sheet names in a separate sheet which is real nice to have.... What I want to know is, can I activate the sheet based on clicking the cell that contains the sheet name in the list ? I would like to be able to find in the list and goto the sheet.

Hopefully I have explained this correctly. Thanks for any help!

Vandan,

I am pretty new to this... How do I add this code? Right now I am running this macro to list the Sheet names:

Please Login or Register  to view this content.

And this code to Search the sheet names:

Please Login or Register  to view this content.

Vandan... Thanks very much! I appreciate the help. This works EXACTLY how I needed it to.