| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display data
How can i have the data in a cell only be shown when the curser is clicked on that cell or the curser is placed over the cell? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display data
In sheet-tab codemodule
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Target, Range("D2")) Is Nothing Then Range("D2").Font.ColorIndex = 2 Else Range("D2").Font.ColorIndex = 1 End If End Sub "DMK" skrev: How can i have the data in a cell only be shown when the curser is clicked on that cell or the curser is placed over the cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I display the actual data in the data field of a pivot chart? | Excel Discussion (Misc queries) | |||
| Look Up and Display set data | Excel Discussion (Misc queries) | |||
| Data display | New Users to Excel | |||
| Display multiple data | Excel Discussion (Misc queries) | |||
| format cell data to display stacked data | Excel Discussion (Misc queries) | |||
Linear Mode
