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").Select
Range("G1").AddComment
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
pbryan@ablcables.com


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

Outcomes