Threaded Comment box

Copper Contributor

Hi All,

 

I am working on a VBA script, were the script is looking for the old comment box in a excel sheet. Below is the value which we used for the old Comment box ( Which is now Note)

 

"If InStr(.Range("B8").Comment.Shape.AlternativeText"

 

it would be great if someone can help me to get the new value for the new comment box. So i can use it in my VBA script.

 

Thanks in advance.

 

 

 

0 Replies