Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
You could try a macro like this and assign it to a button
on a toolbar: Sub NewComment() Dim commTxt As String commTxt = InputBox("Enter comment text: ") If commTxt = "" Then Exit Sub With ActiveCell .AddComment .Comment.Text Text:=Format(Now(), "mm/dd/yy") & _ Chr(10) & commTxt .Comment.Visible = False End With End Sub --- HTH Jason Atlanta, GA -----Original Message----- My question is short and sweet. Is there any way to have the current date automatically appear when inserting a comment. Obviously Excel puts the current user....I'd like to get rid of that and have the date instead. Any assistance you could give would be greatly appreciated. Thanks Eric . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW DO I PRINT THE ENTIRE COMMENT | Excel Discussion (Misc queries) | |||
Comment position..?? | Excel Discussion (Misc queries) | |||
What is the keyboard shortcut to close a comment box in Excel 200 | Excel Discussion (Misc queries) | |||
the red triangle that indicates comment has dissipeared while the. | Excel Discussion (Misc queries) | |||
Comment Indicators | Excel Discussion (Misc queries) |