Excel Userform - Advanced Search and Filter Functionality

[KieronPelling]

Hello,

I've been working on an Excel spreadsheet that will act as a parking permit database. It will contain several thousand entries, so the requirement is for there to be a user form, from which new records can be added, or existing records searched for and edited or deleted.

To help me with this, I found a very useful series of guides here: http://www.onlinepclearning.com/edit...om-a-userform/

Following that guide I was able to correctly set up the example spreadsheet they provide and get it working correctly.

I then created my own spreadsheet, based on this - although it will contain a lot more data.

Most functionality is working except the search function from within the Userform.

From what I can tell, the search function within the userform does not pull over the data from columns B5:AJ5 to AR5:BZ5 as it does when using the Macro on Sheet2 (In Sheet2 the search term is input into cell AP6, then Macro is activated by pressing Ctrl+Shift+A). The data that is copied is then picked up by the 'outdata' named range.

If working correctly I can import all the data, or a matched search, and have it display on the list box within the form.

I can then edit or delete the data within the form.

I've trawled through the code for some time, but can't identify what is missing! Any help offered would be much appreciated.

The spreadsheet is attached.

Thanks for your help. Hope the above is clear, but let me know if I can provide further info.

Kieron

[LeoTaxi]

This will populate the listbox

Please Login or Register  to view this content.

Kind regards
Leo

[KieronPelling]

Hi Leo,

Thank you for your response. This code works perfectly!

Best wishes

Kieron

[LeoTaxi]

Hi Kieron,

glad i could help, is there a reason why the status of case is not Solved ?
if you forgot, please do now

Kind regards
Leo

[KieronPelling]

I've just marked the thread as Solved!

Thanks

Kieron