Re: $$Excel-Macros$$ problem with setfocus

2012-02-17 Thread Shankar Bheema
Thank you Noorain Bhai On Fri, Feb 17, 2012 at 2:59 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Shankar, Please try it.. Private Sub TextBox2_Enter() If TextBox1.Text = Then MsgBox Mandatory Field, vbQuestion + vbOKOnly, Alert TextBox1.SetFocus Else TextBox2.SetFocus End

$$Excel-Macros$$ problem with setfocus

2012-02-16 Thread Shankar Bheema
Dear Experts I am attaching an userform with 2 textboxes. While on exit from the first textbox I have given a msgbox alert for not keeping the box empty. But the setfocus event is not working for it. Kindly guide me. regards shankar sb -- FORUM RULES (986+ members already BANNED for