ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Validations with messages in userform (https://www.excelbanter.com/excel-programming/411425-validations-messages-userform.html)

TUNGANA KURMA RAJU

Validations with messages in userform
 
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.


All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com