message comes up when click a cell

[ThunderstorM]

I have been trying to work out how to get a message to come up when you
click on a cell. I have attached an example of what I am trying to do,
which was in another spreadsheet which I had, but I didn't make it. I
noticed the feature and wondered how to do it? Thank you for your help


File Attached: http://www.exceltip.com/forum/attachment.php?postid=300547 (example.jpg)

 

[Serkan]

use DATA/VALIDATION menu.

i think "Input Message" case a solution for you.

 

[Don Guillett]

Would a DOUBLEclick work? If so, right click on sheet tab>view code>insert
this

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Address <> "$A$1" Then Exit Sub
MsgBox "HI"
End Sub

 

[pfsardella]

Debra Dalgleish has provided a good overview of Data>Validation.

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

HTH
Paul