Create mutiple combo box form controls using Macro

Hi,

I am faced with a weird situation. I have 500 lines of records and each of the line has to be decided upon a particular disposition. So I have to have a combo box control with options to choose from for each of the lines. To do it for 500 lines is a tedious task. Can someone help me with a macro to create 500 combo box controls one below the other in successive cells on the click of one macro?.

I was able to create one, but I am not sure if the attributes could be incremented using a loop to get to the next cell. Kindly help.

Thanks,
Booo

You can try something like this:

Please Login or Register  to view this content.

Then, you can use a For Each loop to do stuff to all those combo objects, like so:

Please Login or Register  to view this content.