OK, I've been scouring the forums to try and find the solution myself before asking for help. I can't seem to find the solution to what is seemingly an easy task, compared to what I've seen some of you doing on here.
I have a userform with a textbox and commandbutton. I want to be able to look for the worksheet name based on what is entered into the textbox and if it matches then open the worksheet.
I'm sorry! I feel like a shmuck! I can't seem to find it in this big 10 lbs. book I have sitting next to me either. I could just be thinking about this in the wrong way.
The only request I have is if you post a response please explain why it works so I can learn from this. I really want to be able to "get this".
Thanks in advance.