View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bergersu bergersu is offline
external usenet poster
 
Posts: 3
Default 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?