+ Reply to Thread
Results 1 to 1 of 1

Listbox items clear after worksheet is closed then reopened

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    Greeley, Co.
    MS-Off Ver
    Excel 2007
    Posts
    1

    Listbox items clear after worksheet is closed then reopened

    I'm working on a estimate spreadsheet. I have 2 worksheets, one is called MATERIALS and the other QUOTE. In the MATERIALS sheet I have a listbox that is populated from a list of materials in cell C. You can choose multiple items in the listbox and then clilck anywhere outside of the listbox and the QUOTE worksheet will open. This worksheet displays the materials selected in the listbox and also displays the price that is found on the MATERIALS worksheet in cell D. A default quantity of 1 is written into the quantity column and can be changed to the correct amount. It works well except for one major problem, after you have built the estimate and saved it then reopen it the items originally selected in the listbox are unselected. The actual quote is saved, but if I go to add an item I have to remember which items have been selected so I can reselect them. Another problem is the quantities get reset to 1. There is a line of code that clears the QUOTE worksheet. I'm not sure how to clear just the materials and rewrite the selected items back in without affecting the quantities and making sure the quantities match up with the selected items. Thanks, Steve
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1