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 wrote: > 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 If > 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 violation