Hello:

I have a userform with many text boxes - it is used as a budget guide and lists numbers from a seperate sheet. I know how to format one text box to read #,##0 (TextBox6 = Format(TextBox6 , "#,##0"), but there must be a command/code that will format them all this way. I am having to enter code for each one. Does anyone have any suggestions?

Thanks!

Scott Settle