Kiwi-123
asked on
Textbox vb
Please can you help with the attached file.
Column R5 comes back with the result "12" when entered on userform1, however I get the error message within the cell; 'Number stored as text', is there a way to change the code so that TextBox15 delivers the data as a number and not as text
TextBox15.Value = Format(.Offset(, 16).Value, "")
help1.xls
Column R5 comes back with the result "12" when entered on userform1, however I get the error message within the cell; 'Number stored as text', is there a way to change the code so that TextBox15 delivers the data as a number and not as text
TextBox15.Value = Format(.Offset(, 16).Value, "")
help1.xls
I could not reproduce that behavior. What do you select on the userform before you click the 'Userform' button?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your help.