populate userform with filtered data

[crossy5575]

Hi all, after the very successful last thread im hoping to go one better!

I have a userform linked to some data - and basically want to show in the userform only the filtered data.

Normally the attached file has 19 records - however if you filter on colour you get 2 records.

on the VBA using the aValues = Worksheets("sheet1").Range("dataset").SpecialCells(xlCellTypeVisible) gives a zero value because the 'dataset' when visible starts on row 3 thus doesnt populate the box.

can anyone help so that the userform just populates the visible filtered data?

regards Simon