Results 1 to 3 of 3

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

Threaded View

  1. #1

    Thread Starter
    Lively Member Daniel McCool's Avatar
    Join Date
    Oct 2002
    Posts
    127

    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.
    Last edited by Daniel McCool; Feb 22nd, 2004 at 11:41 PM.
    "Some love is fire, some love is rust. But the finest, cleanest love is lust." - James Bond

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width