Excel Work Sheet
Posted by Gary O on December 11, 2001 12:37 PM
I am multiplying cell A1 x cell B1 with the value showing in cell C1. I am hiding the value using ;;;. When i highlight the cell i see the formula in the tool bar.I want to see the number value in the toolbar when i highlight the cell. Can this be done, if so how.
Posted by Damon Ostrander on December 11, 2001 2:11 PM
Hi Gary,
Actually, the "tool bar" is the Formula Bar, and I am not aware of any way to get it to display the cell contents rather than the formula. but here is a method of viewing cell contents you might find just as good. Simply add the code below to the worksheet's event code area. To do this right-click on the worksheet's tab, select View Code..., then paste the code into the VBE code pane that appears.
The value of the selected cell will show up in braces in the Status Bar at the bottom left of the Excel window. Here's the code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.StatusBar = "[" & Target.Value & "]"
End Sub
Happy computing.
Damon
Posted by Jack on December 11, 2001 3:03 PM
Damon
Worth a pat on the back that one, just thought i should say
Jack in UK
