Hi Everyone,
I want to create an XL table where every record utilizes the functionality of an ActiiveX combobox. So, anytime a new row is added to the table, an ActiveX combobox must also be added on that row, and its LinkedCell property set to a cell on the corresponding row. The end users may need to add multiple rows at a time, so I do not want them to manually make those updates on each box. So, I need to call a procedure that inserts a given number of rows to the table, along with the comboboxes with their LinkedCell property set to the correct cell.
I would appreciate the help in figuring out how to:
1. write an iterative code for generating a set number of comboboxes and setting the properties of each
2. Inserting a given number of rows to the table
Thanks in advance
I want to create an XL table where every record utilizes the functionality of an ActiiveX combobox. So, anytime a new row is added to the table, an ActiveX combobox must also be added on that row, and its LinkedCell property set to a cell on the corresponding row. The end users may need to add multiple rows at a time, so I do not want them to manually make those updates on each box. So, I need to call a procedure that inserts a given number of rows to the table, along with the comboboxes with their LinkedCell property set to the correct cell.
I would appreciate the help in figuring out how to:
1. write an iterative code for generating a set number of comboboxes and setting the properties of each
2. Inserting a given number of rows to the table
Thanks in advance
