Dependent combo box in worksheet

[alex09]

hello friends
I know how to display one column in combo box using data validation but I would like to know is it possible to display two columns in combo box? What I am trying to do is automatically fill adjacent cell with corresponding data when I select an item in combo box.
thanks

 

[James006]

Hi,

If you are inserting an ActiveX control ... you can display multiple columns ...

Hope this will help

 

[alex09]

Thanks for reply
I have found an example of how to do multi column combo box on worksheet but I would like to know how to fill adjacent cell with corresponding data?