Pulldown menu input values

[Wayne Burritt]

Hi: I have a combo box that return symbols, years, and quarters as
follows...


IBM GE etc
2004 2004
Q1 Q1

The problem is the cells contain formulas and they need to contain the
values themselves. Is there a way to program a macro with the combobox that
puts them in as values? I know I can program a seperate macro to just copy
and past as values but that's combersome. Thanks. Wayne

 

[Kathy]

Hi Wayne
I not sure I understand you correctly -

If you want to display values of cells that contain
fromulas in a comboxbox well here you go:

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

In the properties window of the combobox in the
"FillListRange" field type in D1:E1
The value displayed in the comboBox will be 3,5

But make sure you are in the design mode or you will not
be able to access the properties window.

Good Luck