Question regarding activating sheets

[DNiersbach]

Hello all,

I have a userform with a name dropdown and a date text box. How do I write a macro to activate a sheet based on that information?

I have a cell on each sheet equal to the name of the sheet. I.E. B1="John 07-15" which the sheet is named as well. If a user enters John and 7/17/15 I need it to activate the John 07-15 sheet.

Thank you guys!

 

[Smitty]

Welcome to the Board!

Please continue in your Original Thread.

It helps prevent duplicate work on your behalf. If you feel like you thread has fallen to far back to be noticed you can always reply to it with "bump", which will move it back to the top of the forum.