Home

Threaded Comment box

%3CLINGO-SUB%20id%3D%22lingo-sub-481944%22%20slang%3D%22en-US%22%3EThreaded%20Comment%20box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-481944%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20on%20a%20VBA%20script%2C%20were%20the%20script%20is%20looking%20for%20the%20old%20comment%20box%20in%20a%20excel%20sheet.%20Below%20is%20the%20value%20which%20we%20used%20for%20the%20old%20Comment%20box%20(%20Which%20is%20now%20Note)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%22If%3C%2FSPAN%3E%20InStr(.Range(%22B8%22).Comment.Shape.AlternativeText%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eit%20would%20be%20great%20if%20someone%20can%20help%20me%20to%20get%20the%20new%20value%20for%20the%20new%20comment%20box.%20So%20i%20can%20use%20it%20in%20my%20VBA%20script.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-481944%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Senthil_0072195
New 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.

 

 

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies