AnsweredAssumed Answered

vrf VRF - Creating "comments" in Excel.

Question asked by VRFuser on Feb 21, 2000
I'm having trouble with adding a comment to a cell in Excel.  The VB code
(recorded from a macro) looks like this:

Range("G1").Comment.Visible = False
Range("G1").Comment.Text Text:="Some Text"

I've tried a formula with:

xl.Worksheets(1).Range("G1").AddComment //didn't like this
xl.Worksheets(1).Range("G1").Comment = "Some Text" // nope
xl.Worksheets(1).Range("G1").Comment.Text = "Some Text" //no.

Does anyone here know how to do this?

Paul Bryan
ABL Electronics Corporation
410-584-2738 x133

This is the "vrf" maillist, managed by Majordomo.  To send messages to
this maillist, just email to "".  Subscriptions and
unsubscriptions are done through the address "".
If you need details, just send a message containing the text "help"
to "".