Restrict textbox entries to numbers

Hi All,

Limited to one textbox, how do I make it so that only numbers can be entered?

Additionally, I'd like to add another restriction where the number entered must be less than the value of another textbox.

Thanks so much for the help!

Norie,

Thank you! They both worked like a charm!

A follow up question which might be a bit tougher. I have 3 combo boxes with dropdowns to select the date. Is there a way to write a similar restriction code so that the concatenated value of the three combo boxes is greater than today's date (which is listed in another textbox if that helps)?

I tried this but it didn't function correctly:

Please Login or Register  to view this content.

Please note that the code for the date textbox is:

Please Login or Register  to view this content.

Thank you for the help, it's great.

In the userform, there are three comboboxes in a line. Each one has a dropdown list. The first has numbers for days of the month, the second lists the months, and third lists a 20 year range.

Perfect! Thank you very much Norie

Hi again,

After doing some further testing, the date restriction isn't working. In the form below (as less than today), it accepts any date:

Please Login or Register  to view this content.

When it appears as greater than today:

Please Login or Register  to view this content.

then it won't accept any date.

Thanks for the help.