Dear everyone,
Referring to subject line attached a excel file with user form, my question is if text box 1 is “” (blank) then while moving cursor to combo box 1 it shows msgbox with “please enter name” if this condition fulfill (means user enter the name in textbox1 then it not supposed to show msgbox. Same with the combobox1 but here condition is kittle bit different. 01) User need to use only drop down 02) If it is not matching as per drop down or blank it need to show msgbox “value not matching as per parameter”. What I used If textbox1=””then Msgbox “please enter the name. End if If combobox1=”then Msgbox “value not matching as per parameter” End if And run the macro whether value is there or not it showing msg box Please help. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
Book1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
