This example shows how to create two buttons to fill up two particular colum in an Excel spreadsheet.
Tested on Excel 2000 and 2007
Workbook1.xls
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: