J
Josh Sale
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
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