Episode 2493
Why is the drop-down arrow not showing up when I create the Excel validation with VBA? It appears after I click Save. But I don’t want to save since these numbers are a temporary scenario and I plan on closing without saving.
Also: Using the Selection Pane in Excel to see all shape names
How Excel names shapes.
Why Excel renames Shapes during workbook copy
How to use VBA to detect which shape was selected.

Table of Contents
(0:00) Bug with Shapes in VBA
(0:31) Excel Validation drop-down arrow missing
(3:05) VBA code to delete shapes
(4:07) How Excel Names Shapes
(4:44) Selection Pane in Excel
(5:47) First Validation arrow is named
(7:01) Shapes names restart with new sheet
(7:48) Shapes renamed after Sheet Copy
(9:26) VBA properties for Shapes
(9:50) VBA code to detect which shape clicked
(11:37) Book for learning Excel VBA
(12:02) Thanks for watching