+ Reply to Thread
Results 1 to 5 of 5

Textbox value decimal problem

Hybrid View

mqdias Textbox value decimal problem 08-22-2007, 06:11 AM
Steel Monkey Textbox value decimal problem 08-22-2007, 07:28 AM
mqdias here it's a file with an... 08-22-2007, 08:36 AM
mudraker Works perfectly. Messagebox... 08-22-2007, 08:50 AM
mqdias It's quite strange because in... 08-22-2007, 09:30 AM
  1. #1
    Forum Contributor
    Join Date
    12-26-2006
    Posts
    189

    Textbox value decimal problem

    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?

  2. #2
    Forum Contributor
    Join Date
    11-23-2005
    Location
    Perth, Australia
    Posts
    218

    Textbox value decimal problem

    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.

  3. #3
    Forum Contributor
    Join Date
    12-26-2006
    Posts
    189
    here it's a file with an example.

    Just enter a decimal value in the textbox

    Thank you!
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    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 assisted or failed to assist you I welcome your Feedback.

  5. #5
    Forum Contributor
    Join Date
    12-26-2006
    Posts
    189
    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?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1