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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COUNTING THE SAME VALUES IN A SHEET 3
Baffeling IF statement 7
Adding a VLookup to an AutoComplete ComboBox 0
Funtions return wrong result BUG in Execel ??? 8
problem with time subtraction 7
SUMIF "value if false" not working 2
increasing or decreasing a cell 16
wrong result if function values over 256 4

Top