Hi,
I'm having a problem: when i enter a value in a textbox in my userform, if the value is decimal, like 25.68, it doesn't recognise de dot "." and assumes it as 2568.
Note that the variable for that textbox value is "double".
What is happening?
Hi,
I'm having a problem: when i enter a value in a textbox in my userform, if the value is decimal, like 25.68, it doesn't recognise de dot "." and assumes it as 2568.
Note that the variable for that textbox value is "double".
What is happening?
Im not sure whats happening, i am unable to get the error that you are having. When i try it does recognise the decimal.
Maybe if you uploaded a sample workbook we could have a closer look and hopefully find a solution.
here it's a file with an example.
Just enter a decimal value in the textbox
Thank you!
Works perfectly. Messagebox displays exactly what was typed in, including decimal point
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
It's quite strange because in Excel spreadsheet if i use the same numpad dot key, it assumes like ","
Only in VBA it doesn´t reconize the same key as a decimal separator.
Does anyone knows how to overcome this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks