Can a conditional cell formula reference data selection in a comb.

T

t_nellis

I am setting up a conditional formula that changes depending upon the day of
the week that it is processed on. Can a combo box's value selection be
referenced in a cell fomula?
 
P

PCLIVE

I'm sure someone else will answer you more clearly than myself. However,
you can set your combo box selection to a 'Linked Cell'. This will be the
cell you want your selection to show up in. The linked cell is set within
the Combo Box properties.

Once you've linked a cell for your results, you can then reference that cell
in whatever formula you want.

HTH,
Paul
 
Top