how to lookup combo box into textbox in excel VBA

[dawood]

Hi guys

Hope you are doing good.

I have gotten the attached Excel sheet from internet and modified as per my requirement.

But i having problem with some textbox which i (located in the sheet name "MAIN")newly added and does not populate the item description while the item code selected in combo box.

If any one kindly solve this issue,it would be a great favor for me.

Thanks

Dawood