• 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


  • 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


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