Unfortunately I seem to have caught the VBA bug and now want it to do 'everything' for me!
Here's the scenario . . .
A database contains lots of client records. A display sheet contains a drop-down list courtesy of Data Validation. When a client is selected from the drop-down list the user then clicks a button which executes some code to drag all the details for that client from the database into the display sheet. It's working quite nicely (thanks to the folks who helped me with the code) but what I would like to happen is for the records in the display sheet to be cleared when the user changes the client in the drop-down cell, ready for the next lot of data when they click the button for the new search.
I've read quite a lot of old threads on here about WorkSheet_Change procedures and it would seem that Data Validation changes to a cell are not recognised by this kind of procedure. Is this correct? If so, can anyone offer any suggestions as to how I could work around this?
Summing up . . . I would like the search records to be cleared each time the client name in the Data Validation cell is changed.
Can it be done? Silly question that is I know because it seems that you people can do almost anything with VBA!
Help and advice appreciated as usual.