VBA_Rage
New Member
- Joined
- Mar 12, 2009
- Messages
- 2
This may sound like a simple question but I really can't find the answer!
How can I restrict the values entered in a user form. Example - I have a text box set up in a user form that prompts for inputs that will only accept numbers - but I want to restrict that further by only allowing the user to enter a number between 10 and 15. I can't use a list because I need the flexibility of having decimal entries as well (e.g. 10.27, 14.49, etc).
Any ideas?
How can I restrict the values entered in a user form. Example - I have a text box set up in a user form that prompts for inputs that will only accept numbers - but I want to restrict that further by only allowing the user to enter a number between 10 and 15. I can't use a list because I need the flexibility of having decimal entries as well (e.g. 10.27, 14.49, etc).
Any ideas?