Validations with messages in userform

T

TUNGANA KURMA RAJU

1.I have 2 Textboxes (Textbox1,Textbox2) which are archiving old data from
w/book.I would like to disable them so that no data can be entered into them.
2. I have another set of 4 Textboxes for inputting data.I need validation
code for these Textboxes.
Textbox3=input only date in dd/mm/yy format,if entered wrong msg.
Textbox4=input only numbers,if entered msg
Textbox5=input number less than or equal to Textbox1value.(input not
mandatory can be left blank)
Textbox6 =input number equal to Textbox2 value,input mandatory.If Textbox2
value is 0 or blank diable this Textbox(greyed out).
how to add code these Textboxes.
all my Textboxes are in my userform with multipage control.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top