View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Allllen Allllen is offline
external usenet poster
 
Posts: 341
Default Converting a cell into a comment

Yes, you can do that with a macro like this

Sub AddComment()
Range("A2").AddComment Text:=Range("A1").Value
End Sub

It will put whatever is written in cell A1 into a comment in cell A2.
--
Allllen


"pasbillhen" wrote:

I would like to take information from a cell and convert it into a comment in
a different cell. Is that possible without typing the information into the
comment field.