Updating autoshapes in excel using vba

Once you’ve created a macro, you need a way to execute or call it.

Otherwise, all of your work designing and coding the VBA application would’ve been in vain.

Because the data is input to the function, any time the data changes in your spreadsheet, the chart will update automatically.

I also provide a complete list of Application events, workbook events, worksheet events, chart events, and non-object events.

If you want to have a shorter version of this list of VBA events, I’ve prepared an Excel VBA Events Cheat Sheet which you can get for free by clicking here.

The following table of contents lists the main topics I cover in this tutorial: Let’s start by taking a look at…

In regular English, an event can be defined as “something that happens”.

393

Leave a Reply