Results 1 to 5 of 5

Listbox stopped working after closing and reopening the workbook

This is a discussion on Listbox stopped working after closing and reopening the workbook within the Excel Questions forums, part of the Question Forums category; I have two multi-select listboxes in a worksheet. When I opened the workbook today, neither listbox was acting like a ...

  1. #1
    Board Regular
    Join Date
    Aug 2014
    Posts
    58

    Default Listbox stopped working after closing and reopening the workbook

    I have two multi-select listboxes in a worksheet. When I opened the workbook today, neither listbox was acting like a listbox. They could only be selected as an object through design view. I opened the properties once they were selected and it seemed that they didn't even exist. The properties panel was for the worksheet not the listbox. I can't seem to find the listboxes. The file is saved as a macro-enabled file. Does anyone have any help or ideas about what may have happened to them? It did not do this the last several times I closed and reopened the file.

  2. #2
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Redmond, WA
    Posts
    29,403

    Default Re: Listbox stopped working after closing and reopening the workbook

    See: Office Update breaks ActiveX controls | Excel Matters

    It seems that a security update has broken ActiveX controls.

    HTH,
    Smitty

    Every once in a while, there's a sudden gust of gravity...

    Check out my new book at the Mr. Excel Bookstore!

    Mr. Excel HTML Maker - Post a shot of your sheet

  3. #3
    Board Regular
    Join Date
    Aug 2014
    Posts
    58

    Default Re: Listbox stopped working after closing and reopening the workbook

    What should I do to fix that? Do I have to make a whole new listbox?

  4. #4
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    29,370

    Default Re: Listbox stopped working after closing and reopening the workbook

    If you read the link, it tells you what to do.

  5. #5
    Board Regular
    Join Date
    Aug 2014
    Posts
    58

    Default Re: Listbox stopped working after closing and reopening the workbook

    Thanks haha. I saw the link a few seconds after I posted the reply

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