Hey, I am using Excel 2007, and i have a dynamic list of customer records in a table. I am using vba to add and remove records from the table. For each record in the table I want there to be a drop down list with certain actions such as "Edit" and "Delete". Since there is an unknown amount of records I have to add the drop down box when the record is added to the table. I was wondering what the best way would be to dynamically add this drop down list with vba when the record is added to the table, and then remove the list when it is deleted. Thanks in advance for any ideas.
- Mitch