LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 177
Default Finding attachment point for comment textbox

I'm trying to figure out how to navigate from a textbox that contains a
comment object back to the worksheet cell that the comment is associated
with.

The case begins with the user selecting the comment textbox
(TypeName(Selection) = "TextBox" and Selection.ShapeRange.Type = msoComment)
and then running one of my macro's to manipulate the comment.

The textbox's TopLeftCell and BottomRightCell are relative to where the
textbox got popped up (or was moved by the user) so they don't help.

I just can't figure out how to crossover in the Excel object model from the
textbox that is displaying the comment to the Range.Comment that actually
contains the comment.

Any suggestions?

TIA,

josh


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I add a footnote or comment to a data point in a chart? alkalied Charts and Charting in Excel 3 April 4th 23 10:39 AM
how do I add a hidden comment to a point on an excel graph stenor Charts and Charting in Excel 0 May 14th 10 09:09 AM
Fix a comment to a moving datum point in a line chart JLS Charts and Charting in Excel 1 November 7th 08 04:10 PM
How do I add a comment to a data point in a chart? erin_taylor Charts and Charting in Excel 2 June 14th 06 08:52 PM
Positioning the Insertion Point in a TextBox DennisE Excel Programming 2 February 2nd 04 03:47 AM


All times are GMT +1. The time now is 05:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"