logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Tuesday February 3rd, 2026

Tip of the Day | Tuesday February 3rd, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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  ›  Display VBA Selection Type (Range, Chart, Picture, etc.)

    Choose your language preference below

    English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

    Trustpilot
    Download  


    • 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 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.