Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Why not just datestamp it yourself? Another thing to consider, if someone put a comment on the code an then put another comment, it is going to overwrite the first comment, the below code will make it so the it adhere to existing comments. If you don't want that feature, just change the Temp = line to Temp Date & " - " & comment Sub Add_comment() Dim comment As Variant Dim Temp As Variant ActiveSheet.Unprotect Password:="55555" comment = InputBox("Enter Comment") If comment = "" Then Exit Sub Temp = ActiveCell.NoteText & Date & " - " & comment ActiveCell.NoteText Temp ActiveSheet.Protect Password:="55555" End Su -- Bearacad ----------------------------------------------------------------------- Bearacade's Profile: http://www.excelforum.com/member.php...fo&userid=3501 View this thread: http://www.excelforum.com/showthread.php?threadid=56294 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Positioning Userforms, InputBoxes | Excel Discussion (Misc queries) | |||
InputBoxes Exceptions | Excel Programming |