unique filter on userform

Hi all,

i have a button on a worksheet that when clicked goes through a column and returns a unique list that i use in data validation list (See below)

however what i would like to do is apply that same theory to a button on the userform as i have a combobox on the userform that has the same data in as the combobox on the sheet

Please Login or Register  to view this content.

Ttry and adapt this code:

Please Login or Register  to view this content.

Make sure that the RowSource property of the combo is blank.

just leaves me with a blank combobox....puzzled

what im trying to do is select and date and truck then return data in that row

See my example.

Look where the data is, maybe not in Sheet1 - see my code.

Make sure the code is looking at the correct sheet.

userform is called:- UF_VehStats

here is my workbook

Worked perfect to me

Just put:

Please Login or Register  to view this content.

worked that time but how come its got an empty line in the combobox. thank you very much btw

Originally Posted by Learning ExL

worked that time but how come its got an empty line in the combobox. thank you very much btw

Try this:

Please Login or Register  to view this content.

many thank sir