Good afternoon all,
There are many sites showing you how to fill data into a ComboBox.
What I am looking for is how to fill it will data that isn't a list store in Names.
Here's what I have in a sheet 'FOI References':
Column 'Q' is where a Customer number is stored, a UMRN
Column 'A' is a consequtive file number allocated to each file
Column 'D' is the date the row/file was created
I have a Textbox where a user will enter a UMRN number. THe UMRN can appear several times as we have repeat Customers.
What I am after, is a way to enter the UMRN into the Textbox, then have a search function that will look at Row 'Q' where the UMRN numbers are stored and create a list in a comboBox using Column 'A' and Column 'D' values for each row that contains that UMRN.
I hope this makes sense. I am sure it is just my search words that I am not getting quite right that is preventing me from getting a hit on how to do it.
Thanks