VBA - Create a series of buttons on a Excel worksheet

This example shows how to create two buttons to fill up two particular colum in an Excel spreadsheet.

Tested on Excel 2000 and 2007


You can modify the button properties, eg color....

Making use of collection class for events with an additional collecion objects for the properties. Download project:

Hunter Jones

Hunter Jones

Next Post

Leave a Reply

Your email address will not be published. Required fields are marked *