Can't work with imported form in Excel *RESOLVED*

I am developing some VBA forms for an Excel workbook. The spreedsheets have been updated, as I am constantly updating the VBA forms. So, I want to import my new form into the workbook with the new spreedsheets to create a completed revision of the entire workbook. Everything is working fine, but when i import my VBA form into the new workbook, any code that refers to the VBA form control doesn't work, and I get this error ....

"Can't move focus to the control because it is invisible, not enabled, or of a type that does not accept the focus."

.... the form is visible and enabled, and it can accept focus. So what does this mean? The previous form works fine with the workbook, but when I import the new form to take it's place, it doesn't work. I can understand some syntax being wrong or whatever, but why can't I work with the form. It's as if its not there (I get the drop down of list members for the object in the code view, so I know its being recognized).

Anyone run into a similar problem? Thanks.

Can you post that part of your code. I just did a successful test using a Form not shown to see if I could replecate your problem.




Bruce.

There was some code in the form that was refering to controls that were not there. Apparently the compiler only recognised this when you imported the form.