+ Reply to Thread
Results 1 to 2 of 2

copying coma sign decimal values to userforms and back to excel sheet

  1. #1
    Forum Contributor
    Join Date
    09-30-2009
    Location
    Barcelona
    MS-Off Ver
    Excel 2010
    Posts
    274

    Angry copying coma sign decimal values to userforms and back to excel sheet

    hi,

    this is simple but found no answer yet (like some guy at http://www.mrexcel.com/forum/showthread.php?p=601502)

    the idea is to copy decimal values to userform and back to the original cell when working with coma as the decimal sign (0,15 and so on)

    for some reason the value is passed as 0.15 to the userform and when is copied back to the cell the dot is not understood as a decimal sign and so decimal digits become regualr digits making it a huge number and messing everything

    I could use Replace to change the dot into a coma but I amb affraid of what will happen if a user works with . as decimal sign --- is there no foolproof solutino to that?

    thanks in advance


    Bernat

  2. #2
    Valued Forum Contributor MaczaQ's Avatar
    Join Date
    06-03-2011
    Location
    Poland
    MS-Off Ver
    Excel 2003 / XP
    Posts
    510

    Smile Re: copying coma sign decimal values to userforms and back to excel sheet

    Hello,

    Maybe You do mistake in your VBA code. Decimal value in VBA is represents with "." [dot]
    Value in worksheet like 0,333 or 0.333 should be automaticaly convert before math operation into 0.333.
    (You can see in worksheets value with "," or "." regarding your "Regional settings in control panel")

    Please check attached file, I hope it help you.

    Best Regards
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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