Load a multicolumn Listbox on a userform by looping through your data and
adding the rows that meet the criteria selected by the user.

--
Regards,
Tom Ogilvy

"chris_waldie"
wrote in message
news:chris_waldie.22gbay_1138630501.5588@excelforu m-nospam.com...

This may seem an odd question. I have built an excel document that
effectively works as an issue tracker; new data can be submitted by a
userform, existing data can be edited via a userform.

What I would now like to do is provide a view of what issues are there
without having to view the entire worksheet.

I would like a userform that effectively embeds the worksheet dependant
upon user defined criteria, such as any issues logged by them,
effectively reproducing the effect of an autofilter but within a
modeless userform rather than within the worksheet itself.

The data sheet is basically made up of the following headings, and any
new data is just populated in the next available row.

Name - Position - Manager - Created - Ref - Category - Notes - Closed

If anyone can nudge me in the right direction or has seen something
similar before that would be great.

Thanks.


--
chris_waldie
------------------------------------------------------------------------
chris_waldie's Profile:
http://www.excelforum.com/member.php...o&userid=18853
View this thread: http://www.excelforum.com/showthread...hreadid=506341