loop controls in userform except one textbox

**gkisacik** · 03-27-2010, 01:54 PM

Hello there,

I am using a userform where i have my textboxes, comboboxes with a commandbutton.
When i click on that commandbutton, i would like to reset all the textboxes except one of them.
Currently i am using the following code i got from the internet. But how can I have one of my textboxes unchanged on the userform?

Please Login or Register  to view this content.

Thanks

gkisacik

**zbor** · 03-27-2010, 01:59 PM

Hi gkisacik,

please use CODE tag around your code.

Go to post -> Edit -> Go advanced -> select your code and use # sign around it

**royUK** · 03-27-2010, 02:13 PM

Use the TextBox Tag Property, give the TextBox to exclude a value then this code will work

Please Login or Register  to view this content.

**gkisacik** · 03-27-2010, 02:56 PM

Hello RoyUk,

Not sure it works that way.
To make it clear;
I have textboxes like; txtpercentage1, txtpercentage2, txtpercentage3...
then i have a textbox like txttrial
I would like to have txttrial out of that loop to be set to "".

How can i fix this?

Thanks
gkisacik

**Marcol** · 03-27-2010, 03:04 PM

Try this in Roys' Code change

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

**royUK** · 03-27-2010, 03:22 PM

Why not try the code,add anything to the Tag property of txttrial, say x. Then run the code

**Marcol** · 03-27-2010, 03:28 PM

Apologies Roy.

I should have first said that your code works perfectly well.

**gkisacik** · 03-27-2010, 04:02 PM

Hello Marcol,

For txttrial it works fine but not for the other textboxes (txtpercentage1, txtpercentage2...)

Any other suggestion?

Thanks
gkisacik

**gkisacik** · 03-27-2010, 04:08 PM

sorry that i forgot to mention. even with RoyUK's code the textboxes dont get set to "".

I am sending you now the full code; Any suggestion is welcome.

Please Login or Register  to view this content.

**Marcol** · 03-27-2010, 04:21 PM

What are you asking?

txtpercentage1 = "", txtpercentage2 = "", txtpercentage3 = ""............

txttrial = "some text"

If so BOTH variations of the code work.

Are you wanting to exclude other controls, for instance Labels?

EDIT:

Posted before I saw your code.

**Marcol** · 03-27-2010, 05:28 PM

Your code as supplied has two If statements with no End If

I have no idea where this should be fixed, only you know that

Change the code block to

Please Login or Register  to view this content.

Depending on where your If statements end, you may not need these two lines

Please Login or Register  to view this content.

**royUK** · 03-27-2010, 06:46 PM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

The reason that I suggested using the Tag property is that it is easier to maintain, you can add the exception to other TextBoxes or remove it easily this way.

Also,Select case is much easier to follow.

**royUK** · 03-28-2010, 02:48 AM

I pasted incorrectly in the first post, my code should be

Please Login or Register  to view this content.

I can't really see why you need to clear labels

Well spotted Marcol

**gkisacik** · 03-28-2010, 03:05 AM

Hey Thanks RoyUK,

yesterday i could not see it anymore. I wanted to sleep over and start with fresh brains :-).

But with your last post, the code worked better.

Thank you very much
gkisacik

**royUK** · 03-28-2010, 04:30 AM

No problem

loop controls in userform except one textbox

LinkBack

Thread Tools

Rate This Thread

Display

loop controls in userform except one textbox

Re: loop controls in userform except one textbox

Re: loop controls in userform except one textbox

Re: loop controls in userform except one textbox

Re: loop controls in userform except one textbox

Re: loop controls in userform except one textbox

Re: loop controls in userform except one textbox

Re: loop controls in userform except one textbox

Re: loop controls in userform except one textbox

Re: loop controls in userform except one textbox

Re: loop controls in userform except one textbox

Re: loop controls in userform except one textbox

Re: loop controls in userform except one textbox

Re: loop controls in userform except one textbox

Re: loop controls in userform except one textbox

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions