This example shows how to create two buttons to fill up two particular colum in an Excel spreadsheet.
- Create a collection object (Class) grouping the "click" command ofeach button in a single sub.
- It is part of collections of objects on a sheet and not a UserControl.
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.