Results 1 to 4 of 4

Active X droop-down boxes not functioning on spreadsheet

This is a discussion on Active X droop-down boxes not functioning on spreadsheet within the Excel Questions forums, part of the Question Forums category; Hi All, I have a spreadsheet with Active X drop-down boxes, which has been operating sucessfully on several computers, but ...

  1. #1
    New Member
    Join Date
    Dec 2014
    Posts
    4

    Default Active X droop-down boxes not functioning on spreadsheet

    Hi All,

    I have a spreadsheet with Active X drop-down boxes, which has been operating sucessfully on several computers, but now, it will not operate on 2 of them. The drop down boxes are not selectable and when I look at the code, it has stopped at the line:
    Me.ComboBox1.ListIndex = -1
    Can anyone let me know why this line has caused a problem after all this time?
    Thanks in advance for any help given.

    Bill

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092

    Default Re: Active X droop-down boxes not functioning on spreadsheet

    Microsoft MVP - Excel

  3. #3
    New Member
    Join Date
    Dec 2014
    Posts
    4

    Default Re: Active X droop-down boxes not functioning on spreadsheet

    Hi Andrew,

    Thanks for the reply. I deleted the .exd files, but I still have the same problem.

  4. #4
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092

    Default Re: Active X droop-down boxes not functioning on spreadsheet

    Microsoft MVP - Excel

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com