the data would be in a particular column - each time, and it is only for one
workbook, and it needs to trigger a comment
ie: village at williams creek - data entered
no kickers - comment

there would be different data entered that would need to trigger a different
comment

thank you

"JulieD" wrote:

Hi audrey

yes, via the use of a worksheet_change event ...
if you'ld like to give us some more information we can help construct this
for you ...
- is the entry of the data into a particular row / column / cells or could
it be anywhere in the workbook?
- is it for a particular sheet in the workbook or could it be on different
sheets?
- do you want a message box on the screen with an OK button or do you want a
cell comment inserted?

Cheers
JulieD



"audrey" wrote in message
...
is there a way that when you enter a "name" into a cell - it can trigger a
comment or note? I have a schedule that when certain items are entered, I
need a note or comment to pop up -
thanks in advance