Active X droop-down boxes not functioning on spreadsheet

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Active X droop-down boxes not functioning on spreadsheet

  1. #1
    New Member
    Join Date
    Dec 2014
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    Microsoft MVP - Excel

  3. #3
    New Member
    Join Date
    Dec 2014
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

      
    Microsoft MVP - Excel

User Tag List

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