View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JP JP is offline
external usenet poster
 
Posts: 103
Default Combo Box Changes When Opening Workbook

I have a combo box that is populated by using the ListFillRange property.
When selecting the combo box item ("product"), the price is displayed in the
next column.
Pretty straightforward. But, there are several products with the same
price. If I select a product with the same price as another product, save
the workbook, and the close it, the next time I open the workbook the text in
the combo box changes to the first product with the same price. How do I
keep this from happening?

Thanks