![]() |
|
#1
|
|||
|
|||
![]()
Private Sub cmdMakeComment_Click()
Dim rng As Range Set rng = ActiveSheet.Cells(4, 4) Set rng = ActiveSheet.Cells(6, 5) Set rng = ActiveSheet.Cells(7, 5) Set rng = ActiveSheet.Cells(8, 4) Set rng = ActiveSheet.Cells(9, 5) Set rng = ActiveSheet.Cells(8, 5) If rng.Comment Is Nothing Then rng.AddComment rng.Comment.Text "It is now " & Format(Now) End Sub |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to Insert Text Into Cells Having Multiple Lines | revans611 | Excel Programming | 4 | 10-24-2011 10:15 AM |
![]() |
OTPM | Excel | 11 | 05-23-2011 11:18 AM |
![]() |
PSYloco | Excel | 2 | 05-14-2011 03:46 PM |
![]() |
VinceO | Excel | 1 | 05-09-2011 06:38 AM |
![]() |
jrasche2003@yahoo.com | Excel | 2 | 02-09-2007 07:10 AM |