Restrict the value entered into a textbox on a userform

[D.Lovell]

Hi,

I want to use vba to restrict the value entered into a textbox on a userform to a percentage amount, upto 2 decimal places.

Lets say it's userform1 and textbox1

Upon entering something into the textbox, if its anything other than a numerical value from 0.00 - 100.00, or to anymore than 2 decimal places... show a message box stating the value entered is not valid and delete what ever was typed into the textbox.

Please can someone do an example code that would achieve this, it would be helpful for me.

Many thanks in advance.

[LJMetzger]

Hi,

See the file associated with post #2 in the following thread. It does something similar to what you want. It checks a value to make sure it is a number (colors the TextBox red if it is not a number). It also checks to make sure a value is within a certain range (colors the TextBox magenta if the number is not in the proper range): http://www.excelforum.com/excel-prog...ml#post3936074

Code for the routine you might be interested in follows (in module ModUserForm1 in the file):

Please Login or Register  to view this content.

Lewis