ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can a conditional cell formula reference data selection in a comb. (https://www.excelbanter.com/excel-worksheet-functions/22674-can-conditional-cell-formula-reference-data-selection-comb.html)

t_nellis

Can a conditional cell formula reference data selection in a comb.
 
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?

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

"t_nellis" wrote in message
...
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?





All times are GMT +1. The time now is 02:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com