How to make 3 < 22 ?

[Sqwid]

Hello,

I have a userform set up that compares the values of two textboxes ('New' and 'Ref'), which occurs every time either textbox is changed. When 'New' > 'Ref', 'New' should change to a red background.

It is currently telling me that 3 > 22.3 and 5 > 49.15, etc. because when 'New' has 5 or 5.00 and 'Ref' has 49.15, it returns 'New' as red.

When 'Ref' is 0.49 or 4.91, this code works. But when 'Ref' has double digit whole numbers like 49.1, it gets confused and compares the starting '4' in '49' with the single digit '5'.

Please Login or Register  to view this content.

I tried using "CDec" but that didn't seem to work. What do I need to do?

Please Login or Register  to view this content.

Thank you much, in advance!

[TMS]

Use CDbl instead of CDec.

[TMS]

And convert them both.

[Sqwid]

Thanks for your quick response!

I tried this before the code (with and without the ".value") but it didn't seem to do the trick. In the Locals menu the .Value was still "Variant/String" after passing through this code.

Please Login or Register  to view this content.

[mjr veverka]

1. Assign text boxes values ​​to variables
2. Examine the decimal sign of a number (in text boxes) and depending on it use the 'CDbl' or 'Val' function
3. You can recognize the decimal sign of numbers in the system with "Application.International (xlDecimalSeparator)"

[TMS]

Post an example. See the yellow banner at the top of every screen.

[Sqwid]

Got it! This likely isn't the sleekest way of doing it, but this is what's worked for me.
I did what porucha suggested and just converted the texbox values to their own variables dim'd as double, and I did this in a separate function.


(SA_TB stands for Surface Area Text Box)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I made a function and replaced "SA" with "Val" so I can do the same for Mass and Volume.