logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Display VBA Selection Type (Range, Chart, Picture, etc.)

ASAP Utilities  › Info & List  ›  15. Display VBA Selection Type (Range, Chart, Picture, etc.)

This tool shows you the VBA type of the currently selected object in your Excel workbook.
It uses VBA's TypeName(Selection) function to determine whether the selection is a range, chart, picture, shape, control, or another object. This is especially useful when:
  • You are writing or debugging VBA macros and need to know the exact object type
  • You are working with shapes, charts, controls, or external elements
  • You want to understand how Excel treats your selection in code The returned type name is always in English, even if you use Excel in another language. Examples of selection types:
  • Range - a selection of worksheet cells
  • Chart - a chart object
  • Series - a data series inside a chart
  • Axis - an axis inside a chart
  • LegendEntry - a legend item
  • DataLabel - a label inside a chart
  • Picture - an inserted image
  • Rectangle, Oval, TextBox - shape objects
  • GroupObject - a grouped shape
  • Button, DropDown, ListBox, CheckBox - form controls This tool helps you identify exactly what you've selected, which can help when writing or editing macros or debugging issues.

    Starting this tool


    Info & List  ›  15 Display VBA Selection Type (Range, Chart, Picture, etc.)
    Additional keywords for this tool:
    selection type, Excel selection type, VBA selection type, identify Excel selection, Excel TypeName, find object type, what is selected, determine selection type, VBA object type, Excel range or chart selection, detect selection type, recognize selected object, find type of selected item, identify Excel object, check selection type



  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.