hm - if i understand your question, i think you're asking about a 'god
function' you can call to populate the box ..

what you'll want to do is create a new class module (right click on
modules, and then pick class module). and then put your code there in a
function. for each place you want to populate the drop down box - just
"call myFunction"

Public Function myFunction
<put your code here
End Function