Userform with textboxes to update table with numeric values instead then string-values.

Hi!
I have created a userform so some users can add new records into a table/database in Excel. I am using textboxes on the userform, with some validations.
The issue for me now is that after all the textboxes has been filled with values, the values is pasted into the table, and then the next record shall be added. This works great,
BUT the problem is that the values added into the table is added as string values, and not as "percentage-values". An example: A value in the table will be addes as "5%" (with the green triangle in the upper corner of the cell)
instead of as aVALUE of 5%.

Is there a way to make Excel understand that the values in the textboxes should be added into the table as values, and not as text-strings?
Have thought about "exit events"? What I don't understand though is how to get the exit events to "kick in" when ALL the values in the textboxes are "copied" into the table? The exit events, as I understand them , are connected to each
individual text-box, and not all of them at once....

When I have filled in all the textboxes in the userform I have a "cmdADD"-private-sub that adds the values into the table.

Any ideas?
Best Regards from Sweden
Björn

If the user is entering 5. (with % understood) then the code that writes the 5 must do the division and write 5/100 to the cell.

If user is writing 5%, then XL will think string. So dont allow characters. Or trim out bad chars before the write.

Brilliant!
That should do the trick....
Thx m8!

Yep, that did it! Thx a lot!