What VBA event should I use to auto populate a combo box?
Posted on 2011-09-08
I wrote the code to download data from a database, to fill the Named Ranges used by ComboBoxes. I want this download code called often, but not just before they open the ComboBox, since that will cause a delay (I think).
I would like to find that event so I can do a performance test, since that's the best time to get the freshest data, as they open the ComboBox.
Secondly, I need another event I can respond to where I could put this code to dowload the data, as an alternative.
What can you suggest?? Opening the Combo is the first I should try.
I am new to coding in Excel.
Please let me know...