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
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