AL_XResearch
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The indicators themselves have no official name that I know of. I suspect what your third party add-in does is create Smart Tags.
ASKER
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).
ASKER
It was my error but Rorya was spot on.
ASKER
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