Dear torachan,
Thank you very much for the input and also the sample worksheet. Need to go through it calmly and understand the code.
I have to workout little bit to rewrite the code for my project as there are multiple comboboxs with linked sub comboboxs.
One thing I observed is that, if I open the application I cannot click on any other excel that are working parallally.
I cannot get/copy the info from other excel unless I close the userform. why is that?