Printing integers from a userform
I have a userform on an excel workbook that takes numerical input from a user
and should paste those values to another workbook. This works fine; however, it pastes the numbers as text format instead of number format. How do I get the values to be number format not text? Thanks for any help |
Printing integers from a userform
If, for instance, the value is entered into a textbox1:
Sheets(2).Range("A1") = CInt(UserForm1.Textbox1.Value) or Sheets(2).Range("A1") = CLng(UserForm1.Textbox1.Value) The conversion function CLng gives a larger limit on the number of digits that Excel will handle without sending an Overflow message. "Brad" wrote in message ... I have a userform on an excel workbook that takes numerical input from a user and should paste those values to another workbook. This works fine; however, it pastes the numbers as text format instead of number format. How do I get the values to be number format not text? Thanks for any help |
All times are GMT +1. The time now is 02:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com