Hey Mangesh,

I open UserForm1, I load TextBox1 and enter to TextBox2. When I exit
TextBox2, Frame1 becomes visible and the error pops up. CBox1 is
inside Frame1. If I rem out (use an ') CBox1.SetFocus, the focus goes
instead to the "Save" button.

Here is the code that fires upon exiting TextBox2:

Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean)
BankFrame.Visible = True
CBox1.SetFocus
<Snip
End Sub

Thank you for looking at this and any suggestion you may offer.

-Minitman


On Fri, 5 Nov 2004 03:08:27 -0600, mangesh_yadav
wrote:


When do you get the error. When you open the UserForm or when you open
the excel file you get the run-time error...?

And where have you placed the code Combobox1.SetFocus?

Mangesh