Dear Mahapatra,
It can simply be done by using data validation.
Use following formula under custom option of Data Validation:-
=AND(LEN(A1)=8,LEFT(A1,3)=SCN)
Sample file is also attached with this email.
Best Regards,
DILIPandey
On Fri, Dec 3, 2010 at 4:57 PM, Raj Mahapatra rajafs...@gmail.com wrote:
HI Group,
I want to restrict some fields in user form as we have data validation in
excel.
can you please suggest me the macros using data validation
following are my requirements
1. I want to restrict to 8 digits in a text box, in which first 3
characters has to be SCN
2. I want to use combo box as drop-down list.
thanks in advance
Rajesh Mahapatra
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts
Custom Drop down by DILIPandey.xls
Description: MS-Excel spreadsheet