Percentage calc on userform

Posted on 2012-08-28
Last Modified: 2012-08-29
Hello Experts,

The Percentage calc on the Index field returns ie: 6500% when entering "6.5" with the userform keypad, it should return 6.5%. The percentage calc functions correctly when using a hardware keyboard. Can the code be modified to return the correct value?

Question by:biker9
    LVL 8

    Accepted Solution

    Probably when entering using the keyboard, % is being attached to the number? Either you add % on the userform keypad or configure the field that when no % is found on the entry, divide it by 100.

    Author Closing Comment

    Thanks for the help, this helped towards the solution.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now