Format Multiple Textboxes with One Code

[reberryjr]

I have several textboxes that I want to format as currency, and several others that I want to format as date (MM/DD/YY). When I say format, I'm referring to displaying the desired format in the textboxes themselves. I realize that I can format the textboxes individually, but I'm curious if there's a way to format multiple textboxes in one code set. I've looked online and I'm not seeing anything that says you can, but I'm not sure that is accurate. It seems like there would be a way. Maybe something in the Initialization of a UserForm that says IF Control = X or Y or Z THEN FORMAT as "$#,##0.##"?

 

[Tom Urtis]

Depends on how many you mean by "several". If you have 1 to maybe up to 5 or so, and you will always have those particular textboxes meant for the same format, then doing them individually using the Change event is practical. If you have a dozen or a hundred, then a class module would be the way to go; plenty of examples on the web (including this site) for class modules.

 

[reberryjr]

Class Modules...hmmm....I haven't had the opportunity to experiment with those yet. I'll look into them. Thank you!!