Hi,
I'm also interested in the above and have setup a really quick worksheet (sheet1) and created a basic userform with :
Textbox1
Listbox1
CommandButton1
When i click the command button assigned to butFindAll i get the following error :
Runtime error '13'
type mismatch
the debugged then highlights : ArrayOfMatchingRows = Application.Transpose(DataArray)
In column A i have my Dates, displayed as dd/mm/yyyy (UK format).
Now, if i change the range that the code looks through to D
which contains a Dealer Code rather than a date then the listbox is then populated but with the data from column D onwards.
So...
1) Why is the date causing a problem?
2) How can I still use column D (or others) as my search criteria and still have all the data in the listbox?
3) How can i restrict what data it shows in the listbox, for example perhaps just columns A, D, F & H?
-----------------
You also mentioned that it would be possible to create on this userform a way to edit the data and have it update what has already been entered.
Would you be able to advise how this can be done?
I weould prefer to use one userform that has the search and editing functions in one rather than two forms or forms with multiple pages if at all possible.
Many Thanks,