Can you automatically add a comment to a cell

  • Thread starter Thread starter Mally
  • Start date Start date
M

Mally

Hi all

Is it possible to automatically add a comment to a cell
once it has been selected.

The cells currently have data validation to only allow
you to enter certain letters and conditional formating to
change the colours once these letters have been selected.

I would like it to add the current date and time when any
of the letters have been selected using the drop down box
through data validation.

Thanks

Mally
 
Private Sub Worksheet_Change(ByVal Target As Range)
Target.ClearComments
Target.AddComment ("Date and Time Last modified " & Now())
End Sub
 
Tools|Track Changes>Highlight Changes... and check 'Track changes
while editing'. This will give you a history for each cell showing
who changed what and when.

Note: this will share your workbook, which causes some Excel features
to be unavailable. See Excel help for details.

Have fun!


Hi all

Is it possible to automatically add a comment to a cell
once it has been selected.

The cells currently have data validation to only allow
you to enter certain letters and conditional formating to
change the colours once these letters have been selected.

I would like it to add the current date and time when any
of the letters have been selected using the drop down box
through data validation.

Thanks

Mally
Click to expand...

Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers
 
Back
Top