Ho w to insert a comment to excel cell through DDE with VB

[alberto1974]

Hello everybody I was wondering if somebody knows how to insert a comment to an excel cell using DDE commands I was experimenting with the example "LinkExecute Method Example" from VB, but I couldn't insert a comment to the cell I was using the excel command "NOTE(add_text, cell_ref, start_char, num_chars)" from XLMACR8.hlp, but I always get the error message something like this "Foreign application don't accept or recognize the command"

Thank You.

 

[johnwm]

Assuming that you have instantiated an Excel object from VB you can use this with your Worksheet Object:

With myRange
    .AddComment
    .Comment.Visible = False
    .Comment.Text Text:="My commentary text"
    End With

You can often get a good idea of the VB code to use from using the Macro recorder in Excel, then going to the VB Editor in Excel and copyinhg the code from there. You will need to change the object references of course.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[strongm]

Is there a particular reason you want to use the now rather aging DDE?