A better Case (was "Create Loop with Case statement")

**Rick_Stanich** · 09-16-2009, 10:24 AM

In the code below I am having trouble creating a loop to check the contents of TextBox1 as it can have upwards of 8 characters. This case statement works fine as long as the character count is one.
How do I count how many characters are in Textbox1 and then loop thru them? Am I on the right thought track?

Please Login or Register  to view this content.

Any hints, tips or examples are appreciated.

**StephenR** · 09-16-2009, 10:32 AM

Not sure if you need such a loop if you're just replacing characters as you can do a partial match?

**Rick_Stanich** · 09-16-2009, 10:44 AM

I dont follow, Partial match?

**StephenR** · 09-16-2009, 10:46 AM

With Find and Replace you don't have to match the entire cell contents. Try it from the worksheet and you'll see.

**Rick_Stanich** · 09-16-2009, 10:50 AM

Ok, I understand that now.

I will see how I can apply that in a TextBox.
Hmm, does it matter if the all of this is in a userform?

**StephenR** · 09-16-2009, 10:56 AM

I would have thought it should still work, but what do I know. Report back and put us out of our misery.

**Andy Pope** · 09-16-2009, 10:59 AM

like this perhaps.

Please Login or Register  to view this content.

**Rick_Stanich** · 09-16-2009, 12:55 PM

Oh sure, now see what you did!?
Now I have to edit some umpteen pages and condense them to about 1 page.
Thanks a lot!

Thanks to all.

A better Case (was "Create Loop with Case statement")

LinkBack

Thread Tools

Rate This Thread

Display

A better Case (was "Create Loop with Case statement")

Re: Create Loop with Case statement

Re: Create Loop with Case statement

Re: Create Loop with Case statement

Re: Create Loop with Case statement

Re: Create Loop with Case statement

Re: Create Loop with Case statement

Re: Create Loop with Case statement

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions