Is there a way to format all TextBoxes on a UserForm the same at one time?

**D3Pratt** · 04-01-2009, 06:10 PM

I have 30+ Textboxes on the form.

In the process of entering data the textBoxes get different .BackColor settings.

When the reset command button is hit the boxes stay the same colors, so I was hoping that I could reset them with a single command rather than 30+ lines of formatting code.

**D3Pratt** · 04-01-2009, 06:55 PM

I hate to admit it, I strayed...

I found this on (shudder) another site. but since it works and I couldn't find anything here, I'll post it for posterity.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**shg** · 04-01-2009, 07:02 PM

If you're cross-posting without links, we have a problem.

**D3Pratt** · 04-01-2009, 08:26 PM

There was no cross post. I found the answer using a search on Google that sent me to a different site.

**shg** · 04-01-2009, 08:37 PM

Thank you. That's an honorable way to be unfaithful

I always use Google to solve Excel problems, and am not surprised when I find links right back to here -- I agree in casting a net as wide as possible.

**royUK** · 04-02-2009, 03:35 AM

Looping through controls on a UserForm has been covered here many imes, possibly your serch terms didn't find it. Here's some alternative ways to try. I thinkk it's best to refer to the Control as MsForms.Controls - I have had errors in the past by not using MsForms.

Please Login or Register  to view this content.

**D3Pratt** · 04-02-2009, 08:33 AM

Thanks Roy! The problem was, that during my search (and me being a noob) I didn't know what I was really searching FOR, I didn't know I needed a loop, I was looking for a single global TextBox Command. So I did a search based on the problem I was having and found some other thread started by a similar thinking noob.