Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004

    Unanswered: save multiple listbox picks after close?

    I'm very new at this, so sorry if my question is a little dumb.

    I created a worksheet using VBA. In one column I need a lisbox that allows users to choose multiple items. I made a listbox that does this, but if I save and close the file, when I open it back up all the choices are erased. They aren't gone when you open it, but within .5 seconds after opening it the listbox goes blank. It almost looks like it is a macro, but I didn't program a macro like that and I never hit any buttons to start a macro. What is going on?

    Any help is appreciated.

  2. #2
    Join Date
    Dec 2003
    Ottawa, Canada

    You don't need to use VBA to create drop-down lists. Go to the menu "Data/Validation" select "List" and then submit a list of values separated by commas or a range. With this approach, you can have 1 cell or 1,000 cells with a drop-down list to choose from and you don't have to maintain each and everyone of them. Just copy/paste the cell in which you have created the DDL to thousands of cells.

    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick

  3. #3
    Join Date
    Jan 2004
    That doesn't seem to solve my problem though since I need multiple options displayed and saved at the same time. Am I missing something?

Posting Permissions

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