Doug,

Yes that is one place it can go.

It can be put in the Initialize section that is invoked when the for is
loaded into memory, the Activate section when the form is displayed, or it
could be driven by any number of other events, such as clicking a button.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Doug" wrote in message
...
Chip,

Thank you. I now understand what you mean. But the code goes in the
Activate section that gets called when the userform first opens up, correct?

Thanks.

Doug