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
Bookmarks