View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Angeles Angeles is offline
external usenet poster
 
Posts: 33
Default Add User Name to Comment

It worked !

Thank you very much :)

"john" wrote:

ActiveCell.AddComment "Attribute was added on " & Str(Now) & _
Chr(10) & " it was added by " & Application.UserName

should work
--
JB


"Angeles" wrote:

Hi , how can I add the current User Name to comment ? I am using the line :

ActiveCell.AddComment ("Item was added on " & Str(Now))

I want to set :

ActiveCell.AddComment ("Attribute was added on " & Str(Now) " , it was added
by " )

Thank you