UserForm TextBox formats - Display as Decimal, Read as Percent. Possible?

I have a TextBox on a UserForm.

I want the end users to enter a % in this box.

If the end user enters a decimal, I want the value to be automatically converted to a % (macro change event)

However when the End User presses the Save command button on the form, I want this same text box value to be read as a decimal.

Is this possible?

Thanks +1

Just an update. I had some issues with trying to get the code work in real life. I have edited the code so the userform checks/returns the values by a custom function. Below is what I have come up with. It has errors (which are noted in the comments)...

Please Login or Register  to view this content.

Originally Posted by AlphaFrog

If you enter .02 you get 02.0% returned. If you enter .2 you get 20.0% returned. Isn't that correct?

Change this "00.0%" to this "0.0%" to remove the leading zero.

You could enter decimal values like .002 and get 0.2% returned.

Thanks again AlphaFrog.