Combo Box Changes When Opening Workbook
the items really don't change but the order is not what is giving me the
trouble. I'll save the product name in the combo box but when opening the
workbook at a later time, i'll see the product i selected for a brief second
and then it switches to the product name which has the same price as the one
I selected in the first place.
"Net_prof" wrote:
If these items do not change, populate the Combobox with the
Workbook_Activate event and reference the cell containing the price with the
.additem property instead of using the ListFillRange property. This way you
can control the order the products show up in the combobox.
net_prof
"JP" wrote:
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
|