I am new to excel programming. I have a problem that, I have to use dynamic combobox. but i am not sure how its to be coded. The senario is I have an excel in which I have two combo boxes one caption as "Number"and the other is "Name". When I select a item in number combo I should get the respective name inthe name combo. However the datas are to be taken from other excel file. Please help me out how to code this.
Bookmarks