Textbox decimal value to cell formula

Hi everybody!

I have the following code:

Please Login or Register  to view this content.

If I run this code it gives me a Runtime error '1004': Aplication-defined or object-defined error, and marks the codeline where I want to add the Textbox value to the cell formula.

If I remove the formatting Sub, and enter an integer value, then everything works great, but when I introduce the formatting option or a decimal number the problem starts again.

How can I solve this problem?

Thanks in advance for your help.

Try adding .value

Please Login or Register  to view this content.

The problem is when you have number long enough to have thousands separator.

use

Please Login or Register  to view this content.

or don't use thousands separator at all in the formatting sub

I was able to reproduce your error and posted the solution for it. Upload your workbook if you want further assistance.

Hi,

What is the decimal separator on your computer and what is the actual value in the textbox?

@xlnitwit is right - the decimal separator could be a reason too.

My solution with converting the textbox value to Double works just fine. I changed my regional settings to match yours and it works.

As I said, with your regional settings my file works just fine with decimal numbers.

Are you entering the decimal numbers in the textbox using a comma for the decimal point, or a dot?

I managed to solve the problem by simply adding a Replace function