Restrictions in Text boxes values
Hi,
I have 2 text boxes to be included in VBA userform with a following criteria's.
Text Box1: Please advice on how to code to accept spaces,hyphen in a text box but at the same time to restrict numbers.
Text box 2: Other way accept numbers alone but not the spaces,alphabetic,hyphens(or any special characters).
Please advice!
Thanks.
Hi Mangai and welcome to the forum.
For your first question, you've asked a very hard one. If you don't know anything about VBA or Userform properties this will a very hard problem. Let me point you to two websites that address this problem using code....
http://gregmaxey.mvps.org/word_tip_p...ext_entry.html and
http://www.mrexcel.com/forum/excel-q...textboxes.html
My suggestion would be to NOT use a Userform and simply have the users type into normal Excel Cells. Then use the built in Validation tools that come in Excel.
https://support.office.com/en-us/art...2-95b6aeeb73c9
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Mangai Venkata
Try
Please Login or Register to view this content.
Thanks for the quick response..!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks