Link to home
Start Free TrialLog in
Avatar of AL_XResearch
AL_XResearchFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Create Excel cell indicator triangle

When you add a comment to a cell or you have a cell which has a number formatted as text the cell has red and green triangles in it's corners.

Two questions:
1. How can I create a marker like this myself ? Ideally in VBA

2. What is the actual name for these indicators ? There must be a technical name. If you look around the web you see a wide variety of ways to refer to these features.
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of AL_XResearch

ASKER

Well lets put it this way: there must be a 'collective' term for the indicators. I have a third party addin that creates it's own indicators on the left-hand side of the cell - in blue.

If you created a shap with VBA then a) they would not move with the cell and b) you would be able to select them with you mouse - as per all other shapes on a worksheet

I am trying to find the technical / collective name of these indicators so that I can do research on them
The indicators themselves have no official name that I know of. I suspect what your third party add-in does is create Smart Tags.
Thanks rorya. It appears though that my question unneeded though. I have just clicked again on one of the indicators - the selection area is very small but it is definitely a shape (of a triangle).
It was my error but Rorya was spot on.