Special Comments on template? This is driving me nuts!

[Big Monkey]

OK so just for fun I open a template mostly because I'm bored.

I see something that I've never seen before and for the life of me I can't find how it's done!

I open say the Sales Invoice template...and when I click on certain cells (The State for instance), and a comment pops up.

Only...this comment doesn't have the little red triangle on the corner and it ONLY appears when you click on the cell...not when you hover/mouseover.

How is this being done? I found no VBA code. It has to be something simple I'm missing...but my brain is friend and I need some sleep.

Although very simple, I love the way it works.

Thanks in advance!

 

[sunnyland]

Hello to you,

This is pretty easy to do indeed.

Every cell can have a validation [ menu Data....Validation....].

If you never used data validation before it allows to restrict entries to a cell. When a non valid entry is entered you can have a message displayed: ie "value must be between 5 and 20"

You can have a message display as well when you enter the cell . This is your comments like ....

Ie : select one cell
Goto menu
Data
Validation
Select Input Message
There you can enter the title and message you want to be displayed when the user select /enter the cell.
Meaning it can be a warning saying: only value between 5 and 20 can be entered.

So the user can have a warning before entering data . But it can be use for anything else to display information.

 

[jindon]

tyr something like this

Private Sub Workcheet_SelectionChange(ByVal Target As Range)
MsgBox "You are in " & Target.Address(0,0) ' using message box
CreateObject("WScript.Shell).popup "You are in " & Target.Address(0,0), 1
End Sub

 

[Big Monkey]

Sweet!

Thanks guys