Hi this one is a bit beyond my present VBA skills.
My data arrays are access queries which contain multiple names (ie: person names) and each name has multiple dates associated with it. Most of the time, I want to pull out all data in the row which corresponds to the most recent date for all individuals (which is easy enough to achieve without a listbox) however, ideally I want a more powerful solution that would allow me to chose any date and/or multiple dates.
Can I insert a listbox that opens automatically whilst the macro is in run mode (perhaps contains a question such as, "what dates do you wish to view results for?"), then allows me to choose one or multiple dates (which are all located in column B for example), then copies the all data in the rows which correspond to those dates?
Is this the best method or should I be thinking about something completely different?
Thanks
Didj
My data arrays are access queries which contain multiple names (ie: person names) and each name has multiple dates associated with it. Most of the time, I want to pull out all data in the row which corresponds to the most recent date for all individuals (which is easy enough to achieve without a listbox) however, ideally I want a more powerful solution that would allow me to chose any date and/or multiple dates.
Can I insert a listbox that opens automatically whilst the macro is in run mode (perhaps contains a question such as, "what dates do you wish to view results for?"), then allows me to choose one or multiple dates (which are all located in column B for example), then copies the all data in the rows which correspond to those dates?
Is this the best method or should I be thinking about something completely different?
Thanks
Didj