Display info in Listbox/Combobox

Good day,

I have a UserForm that show Customer information when selected in ListBox1. I want to make my customer UserForm to also display Columns A, AO and BF from the invDATABASE sheet. Basically I want a ComboBox or ListBOX that shows all the invoice numbers, Totals and Paid/Not Paid from the selected Customer ID. one Customer could have more than one invoice.

Can anyone perhaps help me?

I've attached the excel file for more info.

Thank you very much,

Jakes

Hi Jakes,

I've added the code but you will have to adjust the ranges

Please Login or Register  to view this content.