recognise text box value as a number then format

[mariec_06]

In a userform framebox I have 85 textboxes.

Some can have only alphabetical value (xxxxx), some can have a value for ex "16pv063/xxxx" and some are real amount as text for ex "26387230.53".

In the code, I want
if the textbox value is 0 or "" then make it invisible (this works)

if the textbox value is a real amount to format it as a USD number
for ex, if textbox value is alphanumeric like "16pv063/xxxx" then do nothing
if textbox value is "26387230.53" then to show it in the textbox as "USD 26,387,230.53"

herebelow the code. When I test it it shows me "USD 26,387,230.53" in the code but it is not appearing as such in the textbox on the screen which remains "26387230.53"

Can someone gives me a trick?

Please Login or Register  to view this content.

[pjwhitfield]

Try Repainting the form
Me.Repaint before the End If

[mariec_06]

it works perfect thanks