+ Reply to Thread
Results 1 to 5 of 5

Execution error 91

  1. #1
    Registered User
    Join Date
    02-01-2010
    Location
    Paris
    MS-Off Ver
    Excel 2007
    Posts
    6

    Execution error 91

    Hi all,

    The attached spreadsheet and its userform were created with excel 2007 and I can execute the code with no problems.

    However when my colleague, who uses excel 2003, clicks on the second combobox, he get 'error 91: variable missing' type of error.


    Can anyone advise if I am missing something or if there is some kind of component that needs to be activated on excel 2003? My colleague has alreday executed the MS Office compatibiltiy pack

    Thanks, Arlete

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Execution error 91

    No attached file!!!

  3. #3
    Registered User
    Join Date
    02-01-2010
    Location
    Paris
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Execution error 91

    Forgot file
    Attached Files Attached Files

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Execution error 91

    Try changing the Combobox2_Change code to this:
    Please Login or Register  to view this content.
    Remember what the dormouse said
    Feed your head

  5. #5
    Registered User
    Join Date
    02-01-2010
    Location
    Paris
    MS-Off Ver
    Excel 2007
    Posts
    6

    Smile Re: Execution error 91

    Thanks. Works perfectly in Excel 2003 and 2007

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1