Display data

's Computer Specifications

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?

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Not plot a data series in a chart but still display in data table	mebp	Microsoft Excel Charting	1	19th Mar 2010 05:13 PM
Powerpoint display is cut off on data projector display.	David-DEC	Microsoft Powerpoint	1	16th Jan 2008 04:09 PM
Data Access Page: How do I display data from a filtered table?	=?Utf-8?B?Sm9uYXRoYW4=?=	Microsoft Access	0	9th Feb 2007 11:56 AM
Displaying Xml data in Treeview & AfterSelecting nodes display data in RichTextBox	Guest	Microsoft Dot NET	0	20th May 2005 08:13 AM
using Crystal Reports to display data in my dataset correctly (display the data I selected instead of all the data in table)	JK	Microsoft C# .NET	1	6th Sep 2003 10:10 PM