Hi,

I was wondering if the following is possible and, if it is possible, if someone could point me in the right direction.

I have a large file with multiple userforms. With one of those forms I want to enable the user to go through previous entrees, so that he/she can find the ID number that goes with the previous entree. I cannot use the output table that i use for this, because there are 105 columns in there that the user doesn't need to see. I made a pivot table from the master table, which contains 11 columns. I wanted to use a listbox, but i cannot set the rowsource to this pivot table.

So in short, i'd like to show the entire pivot table that i made in a userform, preferably with search option. Any ideas?

Thank you in advance!

Mathijs