How to hyperlink cell value to userform created worksheet?

**jwichern1** · 02-25-2011, 10:26 AM

I have created a user form that will create a new sheet to match the EmployeeName entered and then on a different sheet copy that EmployeeName to a cell. I would like the code to make the new cell hyperlink to the sheet with the same name. Below is a copy of my existing code:

Please Login or Register  to view this content.

I hope what I am asking for is clear. Any help would be greatly appreciated.

Thanks.

**Andy Pope** · 02-25-2011, 10:40 AM

Please Login or Register  to view this content.

**jwichern1** · 02-25-2011, 11:11 AM

Andy,

Thank you for your quick response. However, I am getting an error message saying "Reference not valid" when I click the link. Do you have any suggestions on how to correct this?

Edit - It appears the issue is caused because the name entered has a first and last name with a <space> between them. Is there a fix for this?

Thank you,
John

**Andy Pope** · 02-25-2011, 11:24 AM

wrap the sheet name in single quotes.

Please Login or Register  to view this content.

**jwichern1** · 02-25-2011, 11:38 AM

That's perfect. Thank you very much for your help.

**J1s** · 06-10-2011, 12:37 PM

I am attempting to have Excel VBA identify the name in the active cell and hyperlink that cell to a sheet within the same workbook that has the same name as the cell? Is this possible? If so could some one walk me through how to write such code?

Thx, J