ComboBox

[JonathanK]

Hi Folks,


I want to use a combobox from say C6:C200. Each combobox in each row will have the same input range. But I would like the Cell Link for each combobox to be a different cell.


Eg. Comboxbox in C6 - Cell Link F6

Comboxbox in C7 - Cell Link F7


And so on...


After creating the first combobox, is there anyway that I can drag and drop the combobox with the Cell link changing? Or do i have to individually change the cell link for each row.

 

[JonathanK]

Any help guys?

 

[NARAYANK991]

Hi Jonathan ,


I doubt that it is possible ; what you can do is create all the comboboxes that you want , and then run a macro to change the linked cell of each combobox to its correct address.


Narayan