VBA userform – convert number to percent

**Kasperlindoe** · 02-12-2010, 08:58 AM

I have a problem with conversion of numbers to percent, that I hope some of you could help me with…

In the attached sample (with macros enabled), you will find the problem when pressing the button “INDTAST DATA” (I apologize for the linguistic challenge, but the XL-sheets are in Danish… To relief – check the crash course in Danish below) and then entering some number in the two last textboxes (called “Forventet ændring i antal timer I næste kvartal (%)” and “Forventet ændring i omsætning i næste kvartal (%)”)… If you enter something there, the result will be multiplied by 100 in the worksheet.

I would like to be able to simply enter a full number – like 12 or 9,5– which will then be entered into the worksheet as 12% or 9,5% (and not 1200% or 950%)… I think the answer lies in inserting some code in the VBA code, when the macro writes the data to the worksheet, but you guys know more about it than I do...

I can, of course, enter a full number in the textboxes – followed by a %-sign, but that will slow down the process significantly as well as increase the risk of errors…

BONUS: Crash course in Danish (to help with the linguistics)
Virksomhed = Company
Kvartal = Quarter
År = Year
Branche = Industry
Fakturerede timer = Billed hours
Faktureret omsætning = Billed revenue
Timeforventning = Expected hours (next quarter)
Omsætningsforventning = Expected revenue (next quarter)
Indtast data = Enter data

I hope it makes sense and that someone can provide a working solution

**JBeaucaire** · 02-12-2010, 09:52 AM

Maybe something like this?

Please Login or Register  to view this content.

Or, since you already appear to have the columns formatted:

Please Login or Register  to view this content.

Or even:

Please Login or Register  to view this content.

**Kasperlindoe** · 02-12-2010, 10:17 AM

Thank you very very much - it's working perfectly!

**JBeaucaire** · 02-12-2010, 10:19 AM

Which one did you end up using?

=======
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].