View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Display excel formula values

http://www.anthony-vba.kefra.com/vba/vbabasic1.htm

http://www.rondebruin.nl/code.htm

http://www.contextures.com/xlvba01.html

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"upquark1" wrote:

how can I display Excel 2007 cell formulas showing input values as they would
be written on paper or solved on a hand calculator (for educational
purposes), not final value and not cell references which are straightforward?
I found VBA code from 2005 which may solve it but I don't know how to get
this code to work as a macro in Excel and Excel doesn't appear to have any
built-in functions to display input values.