Hi
I made one excel, where you can add data through pop-up window.
Added data will be copied into excel sheet.
After that I'm making some of calculations etc.
Problem is that output from user-form is in text, so entered number 10.23 is text for excel and I can't use SUM formula to sum-up values.
If I look cell value then there is yellow exclamation mark and from menu can choose Convert to Number. After pressing it excel will start understand this field as number.
I have tried but haven't found solution how to convert this value to number automatically (with VBA).
So, help is needed
In userForm I have used following line / code to get data from user-form to excel sheet:
Worksheets("Data").Range("c2").Value = TextBox1
Worksheets("Data").Range("d2").Value = TextBox2
Maybe should change this (those) lines?
Also added file about what I'm talking.
PS! To activate user-form press button in page
I made one excel, where you can add data through pop-up window.
Added data will be copied into excel sheet.
After that I'm making some of calculations etc.
Problem is that output from user-form is in text, so entered number 10.23 is text for excel and I can't use SUM formula to sum-up values.
If I look cell value then there is yellow exclamation mark and from menu can choose Convert to Number. After pressing it excel will start understand this field as number.
I have tried but haven't found solution how to convert this value to number automatically (with VBA).
So, help is needed
In userForm I have used following line / code to get data from user-form to excel sheet:
Worksheets("Data").Range("c2").Value = TextBox1
Worksheets("Data").Range("d2").Value = TextBox2
Maybe should change this (those) lines?
Also added file about what I'm talking.
PS! To activate user-form press button in page