Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
*** I Have also posted this Q to the General Section***
In Sheet1 - Cell B4 there is =345.54+58.16+100.50-45.78+52.16 'Displayed as $510.58 In my Sheet31 Cell B6 there is =Sheet1!B4 ' Displayed as $510.58 I need to prove a way for the user to right-click on Cell B6 of Sheet31 and somehow produce a vertical Listing showing (maybe in a Message box): 345.54 +58.16 +100.50 -45.78 +52.16 Can this be done? I can do this in another cell by utilizing the following UDF Function SeeValues(Activecell As Range) As Variant Application.Volatile True SeeValues = Activecell.Formula End Function Any assistance appreciated. Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
View type when opening an attachment | Excel Discussion (Misc queries) | |||
Convert raw planning data into a 'calendar type' view | Excel Discussion (Misc queries) | |||
Drill-Down | Excel Discussion (Misc queries) | |||
drill down again | Excel Discussion (Misc queries) | |||
Type of Drill-down View | Excel Discussion (Misc queries) |