Hi,

I have a UserForm with three frames. I'm setting the focus on an initial ComboBox in the first frame in the Userform_Activate procedure. I can then SetFocus on any Box in that frame. However, when I try to SetFocus on any Boxes in any other Frame, I get an "Object required" error.

Both Visible and Enabled properties of all Boxes are set to True.

I've tried to set focus to the frame first, and also reference the object using Forms!UserFormName!BoxName.SetFocus, but nothing is working.

Can anyone offer any solution?

Many thanks.