Search:

Type: Posts; User: Blue_Wings; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: imputbox change decimal value dot to comma

    Yes, correct.
  2. Re: imputbox change decimal value dot to comma

    I missed your #10 reply and didnīt tried it.

    But answering your question, if I entered 5,88 with a comma everything works fine, it was just to avoid error, since most people uses dot from the...
  3. Re: imputbox change decimal value dot to comma

    As simple as that!
    It Works!

    The confusion was because I wanted to use that same variable "ValorND" to do a calculation while inside the VBA with another variable "ValorND / ValorQuota" , and...
  4. Re: imputbox change decimal value dot to comma

    This last option keeps the decimal part like it should be but, for example in the inputbox 55.7 it stores in the cell 55,7 but as text and not as a number.

    I need it to be a number in the...
  5. Re: imputbox change decimal value dot to comma

    The system uses , for decimals.

    Sorry for all the trouble, all that I wanted was an simple input box to store a value in euros, that most of the times have decimal part, keep it in a variable, do...
  6. Re: imputbox change decimal value dot to comma

    Even with that change,

    If I put in the inputbox for example 55.70 the output from the variable ValorND in the cell "O5" is 55.00 and I wanted to be 55.70



    ValorND = Val(ValorND)

    'I added...
  7. Re: imputbox change decimal value dot to comma

    It works :) but then is resulting in another problem.

    after the calculation is being stored as string in "ValoND" and I was trying to convert it to number but keeping de decimal part, for example...
  8. Re: object variable or with block variable not set

    I will, Thank you.
  9. imputbox change decimal value dot to comma

    Hi, I have been searching without success for the following:

    I have a imputbox to receive euros, if the user wants to insert for example the number 55.20, afterwords I will use that number to do...
  10. Re: object variable or with block variable not set

    Yes you are right, I had the wrong position of the cell, thank you.
  11. object variable or with block variable not set

    Good morning,

    I am a little bit lost here, the code was working fine, I donīt remember changing anything, and suddenly now is giving error.

    Already spend a few hours around this matter and I...
Results 1 to 11 of 11