unusual textbox feature

**cassiopea** · 10-20-2010, 03:12 AM

Hello!

I have a userform and an textbox on it, which has controlsource in cell A1.

If I enter decimal number with two decimal places (exapmle:12,34), everything is fine. But if i enter more than two decimal places, the number somehow "loses" comma, and becomes the normal (non-decimal number). For example, if I enter 12,3456 it becomes 123456. Why this happens? How can I solve this problem?

Thanks In advance

**teylyn** · 10-20-2010, 03:24 AM

When you enter the number

12,34

it is interpreted as text

When you enter the number

12,345

it is interpreted as a number with the US formatting convention, using a comma as the thousand separator.

**romperstomper** · 10-20-2010, 03:37 AM

Don't use the Controlsource. Use one of the textbox events, such as the Exit event, to write the textbox value to the cell using Cdbl. For example:

Please Login or Register  to view this content.

**cassiopea** · 10-20-2010, 03:52 AM

I am new in excel progamming.

Where exactly should I write this code?

**royUK** · 10-20-2010, 03:56 AM

Select the textBox in the VB Editor. The right hand drop down lists the control's events

**cassiopea** · 10-20-2010, 04:59 AM

It works if there is some entry in the textbox. But if there isn't, if someone deletes numbers in textbox, error type 13:type mismatch appears!

**romperstomper** · 10-20-2010, 05:44 AM

I would use something like this in your form:

Please Login or Register  to view this content.

**cassiopea** · 10-20-2010, 06:19 AM

Thank you...

**djatmiko.saputro** · 06-29-2015, 05:07 AM

I found this forum while searching similar problem regarding this textbox problem
I wrote this code for my "data key in" userform

Please Login or Register  to view this content.

When I put 0,86254 (no matter how long the numbers after comma), it will be write as number, but if I put x,###..... (x > 0) vba will remove the comma
I've tried to use this code

Please Login or Register  to view this content.

But still didn't work

Need your advice

**teylyn** · 06-29-2015, 08:09 PM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.