TextBox Value equals worksheet...

[SunRunnerNY]

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.

[Solus Rankin]

Try:

Please Login or Register  to view this content.

[SunRunnerNY]

Thanks but not really what I was looking for. I have a texbox1 set up. I'm trying to tell the userform to look for and open the worksheet based on what what is scanned in for a name.
Don't get me wrong, your input box popped up and I was like, "Dang that's slick!"
So normally you would place the code you posted in a module? Then call it from another userform?
I have an initial userform that pops up giving the user options of tasks to perform. What I am asking for above will open the specific sheet so the user can add data to it from another userform.
I'm probably over complicating the process.

[blue.chio]

or use a combobox...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Solus Rankin]

No that I think that will be simple enough. I didn't know you had a userform. Can you upload a sample workbook (preferably with the userform already it it ) for me to work on?

[SunRunnerNY]

You know what? I like your way. Can you please explain your code a bit. I'm looking at it and I think I understand what it's doing. I need to break it down.

[SunRunnerNY]

By the way...Thanks.

[SunRunnerNY]

or use a combobox...

I had thought about that but then I would need to make sure any new sheets gets added to the range.
It's a bit more than I'm able to do right now.
I'm going to get this project "finished" first then go back and tweak it so it runs smoothly. It's a bit of a mess right now.
Xero Solus - I really like the look of those input boxes. Is there a resouce I can look at to see if I can substitute them for some of my userforms I'm using to write to the sheets?

[Solus Rankin]

Please Login or Register  to view this content.

If you copy and paste this into a button click event on your user form then they can click a button and the inputbox will pop up like normal. It is a way to integrate it into your userform.

[SunRunnerNY]

Please Login or Register  to view this content.

I changed the wording on the MsgBox to fit what I need. The problem is that if the sheet doesn't exist it still goes onto the next userform to input data onto a sheet. It should just say that it isn't a valid entry.
I looked up the input boxes in my big *** book but it only had a few pages. I'm going to look through the forums some more.

[Solus Rankin]

Sorry I missed a line...

Please Login or Register  to view this content.