auto refresh for combobox
 

I don't mind whether I have a Form combobox, VBA combobox of Validate List.
However whichever I use, I need to run a macro to rebuild the list of
entries for the box, when (or just before) the user clicks the drop down
arrow.

I have tried a few things myself, but I have not been successful?

Can anyone assist?

Also, what does the AutoLoad property do on a VBA combobox and where do I
find all those properties documented?

TIA
Paul Lautman