hi - i have an issue with formatting text boxes...... i'm able to format text
boxes with code similar to below....in the userform initialize sub.....there
is another text box which is the sum of TX1 & TX2.....i place the sum line
before formatting and so this works perfectly when the userform opens....

Me.T.Value = Val(TX1 + Val(TX2)

Me.TX1.Value = Format(Me.TX1.Value, "#,##0")
Me.TX2.Value = Format(Me.TX2.Value, "#,##0")
Me.T.Value = Format(Me.TX2.Value, "#,##0")

however, TX1 and TX2 is an input box as well and i've got code to sum 1 & 2
using change event....

Private Sub TX1_Change()
Me.T.Value = Val(TX1 + Val(TX2)
End Sub

this doesnt seem to work becos the sum here is doen off the formatted number
and so the result is not correct....the sum works fine when i remove the
formatting during initialize...

i did a way to....
1. deformat TX1, TX2
2. perform sum of the two and place value back in T
3.reformat TX1, TX2, T after the sum has happened.


thx a lot for your help.