Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I add a footnote or comment to a data point in a chart? | Charts and Charting in Excel | |||
how do I add a hidden comment to a point on an excel graph | Charts and Charting in Excel | |||
Fix a comment to a moving datum point in a line chart | Charts and Charting in Excel | |||
How do I add a comment to a data point in a chart? | Charts and Charting in Excel | |||
Positioning the Insertion Point in a TextBox | Excel Programming |