I have a macro to format the cell in the user form as follows
Iam obviously doing something wrong as this converts the numbers to text. Is there anyway I can get the text box to display the entry for money, but keep the formatting as numeric?
many thanks
Code:
private sub textvaluation_change()
txtvaluation = format(txtvaluation, "£#,##0")
end sub
Iam obviously doing something wrong as this converts the numbers to text. Is there anyway I can get the text box to display the entry for money, but keep the formatting as numeric?
many thanks