Entering worksheet data via user form

Hi,

I have difficulties with entering data into a worksheet from a user form.

The example in the attached file illustrates this. When adjusting the value in the user form with the spin button it seems as the text box-value is treated as text?

When writing directly in the text box, lets say 16,3, it is saved in the cell K3 as text?

Any suggestions are wellcome!

Hello Tellus,

All values going into and coming out of a TextBox control are text. You need to make the needed conversions if the data is to be treated as another data type. The modified code below has already been added to your workbook, which is attached.

[b]Modified UserForm Event Code[/]

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Dear Leith,

you just made my day! You did not only solved my problem but also made me understand why some previous work have failed.

Thanks a lot,
Fred Tellus