Listbox stopped working after closing and reopening the workbook

xenedra13

Board Regular
Joined
Aug 15, 2014
Messages
58
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.
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,793
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
If you read the link, it tells you what to do. ;)
 

Watch MrExcel Video

Forum statistics

Threads
1,095,147
Messages
5,442,650
Members
405,191
Latest member
wedloski

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top