Formatting multiple Textboxes in UserForm

[rameezl17]

Hi all,

I have a userform with 50 textboxes (textbox1, textbox2, etc)

I want to format all of them so that way after the user types in a number, the number formats to the thousands, Like if they type 1000, it’ll show 1,000 on the userform.

How can I do this efficiently so I don’t have to go through every single textboxes and input the code? I’m assuming this is a use for loop? But I’m not sure.

Thank you for your help!

 

[Tom Urtis]

Class modules are made for the situation like you describe. A search for keywords excel vba class modules will yield several helpful links.