vlookup value in a combobox2 based on the combobox1 selection

[camt123]

Hi everyone,

I'm new in this programming stuff with VBA and I need some help in order to see if what I need is possible to make my form to work.

I have a sheet1 called "Record" in excel which contains several columns with several data. In column B3 there is a serial number of a production order (which can be repeated), on the others there are some other informations regarding this serial number. I have already made that combobox1 calls the data on column B3 and do not duplicate the numbers, what I need is that in combobox2, depending on the combobox1 selection, appears the values that I have in column "L" like the vlookup formula in excel and if the value in combobox1 have more than one available choice in column "L" so the combobox2 can show me all of them.

I'm not sure if I made myself clear.

For reference, some of the codes that I have used are not from my work but some other person that help me building my form to work and so far it is doing what I need.

Thanks for any support you can provide!!

[stnkynts]

Submit an example workbook

[camt123]

Hi, Sorry for the late reply. I had some issues with my pc and was unable to do anything.

I will change this post into another one as I will no longer use the vlookup for those comboboxes.

Thanks,