Text box format

[asyamonique]

Me.TextBox381.Value = Format(Val(TextBox381.Value), "#,###,##")

I have over 900 textboxes on my userform.
How can i valid the attached code for all the textboxes in one time, instead of putting them one by one?
Cheers

 

[Marcelo Branco]

Hi,

Maybe this can help

http://www.ozgrid.com/VBA/control-loop.htm

M.

 

[shg]

900 textboxes! Wow!

If Marcelo's suggestion works for you, I'd suggest you take it.

If it makes your form sluggish, there's an alternative that is more complicated and has several moving parts, but each is straightforward.

 

[Marcelo Branco]

900 textboxes! Wow!

If Marcelo's suggestion works for you, I'd suggest you take it.

If it makes your form sluggish, there's an alternative that is more complicated and has several moving parts, but each is straightforward.

Yes, 900 is quite a number for text-boxes on a userform. I'm wondering how the user can handle this...Probably they are not all visible at the same time.

Could you provide a link to your suggestion?

M.

 

[asyamonique]

I will back to you guys.
Cheers