Values in ComboBox

K

Kathy

Hi Wayne,

If I Understand you correctly -
You can display the values of the cells referenced in a
combobox by listing the cells in the properties window of
the combobox under the "ListFillRange".

If A1 = 1
B1 = 2
C1 = 3
D1 = A1+B1
E1 = B1+C1

In Combobox Properties Set ListFillRange to D1:E1
Value in drop down menu will be 3,5
 
Top