ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   formulas in drop down lists (https://www.excelbanter.com/excel-programming/315722-formulas-drop-down-lists.html)

bergersu

formulas in drop down lists
 
I have a form which has several drop down lists. The lists are stored on a
different worksheet and include formulas. When I use the form and choose from
the list, I get the result of the formula instead of the formula in the box.
I'm using the form to fill in information in certain cells and would like the
formulas to go into the cell instead of the answer. Is there a way to choose
a formula from a drop down list and actually get the formula and not the
resulting number?


All times are GMT +1. The time now is 07:31 PM.

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