LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default InputBoxes


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Positioning Userforms, InputBoxes Pflugs Excel Discussion (Misc queries) 1 July 10th 07 06:12 PM
InputBoxes Exceptions ianripping[_42_] Excel Programming 3 April 8th 04 09:34 PM


All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"