• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Two Condition Check

delta

Member
my userform contain 5 textbox 5 label. l will check Two condition.

1 All Textbox are not empty and if those textbox are empty then message box show fill those textbox else macro ADD_DATA run
2 check the dulpicate entry of docuement number (i.e. TextBox1) if duplicate document number is exits then set focus the textbox of document number and change the document number else macro ADD_DATA run.
how to check both condition at once when click ADD DATA Button. i attache the sample file
 

Attachments

Top