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

Click ASAP Utilities › Info & List › 15. Display VBA Selection Type (Range, Chart, Picture, etc.)
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

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

Choose your language preference below

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

List File Names and Properties from Folder...

Count All Worksheets, Chart Sheets, and Macro Sheets

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 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.