Filtered Data in userform

[Macdave_19]

Hi Everyone,

I have have a userform which, based on 3 criteria, will filter a large amount of data.

Once the data is filtered i need to populate boxes in the userform with this data. However i only want to populate data that is left after the filter has been applied?

is this possible and if so how.

the was i am working it is as follows.

once the first reference number is found after the filtering, it is placed into a range (A2) from here the cells below perform lookups and obtain the data i need for the userform. I simply reference the ranges for the userform as below:

FrmNew.TxtCRN.value = Range("A1").value

Any help is much appreciated & thanks for taking the time to read my thread!!

[Greg M]

Hi there,

If I understand correctly, what you're doing is this:

1 - open user form
2 - enter filter parameters using userform
3 - apply filter (using "Filter" button on userform?)
4 - filter is applied to the worksheet data
5 - lookup table on worksheet displays filter output

You want the user form to remain open & display the contents of the lookup table.

Your sample of code "FrmNew.TxtCRN.value = Range("A1").value" suggests that the control on the userform is a text box (which can display only a single value). Do you need a list of values to be displayed or do you expect the filter to produce only a single value?

Have I understood what you're trying to do? Please let me know & I'll see if I can help.

Regards,

Greg M

[Macdave_19]

Yeah that's what i want to do buddy,

the filter leaves a lot of data remaining and that data is found via a series of lookups.

i want certain peices of that data to populate into the userforms textboxes.