Hello
I'm new to VBA and in all honesty have been searching the net and following instructions and copying codes to suit. However, I can't seem to find anything that helps me populate a textbox from the combobox selection. I have a userform with:
First cbx with a rowsource of a dynamic range of a list of suppliers "SupList". Once supplier is selected, I have an advance filter macro. 2 of the columns in this macro shows part numbers and part description for this supplier. I have applied a dynamic range name for these 2 columns "SupPartFilter". This is followed by a delete duplicate macro that only shows unique part numbers only. This seems to work fine.
Second cbx populates with the unique part numbers for the supplier. This works fine too.
Third is a textbox which I would like to populate with the part description but this is where I am struggling. I have tried various suggestions but can't get anything to work:
Would appreciate any help with this so that I can move on to the stage.
Regards
Amita
Bookmarks