Are you talking about a VBA userform?

If so you can use UserForm_Initialize as the macro.

This link might be useful for you... Initialize an Excel VBA User Form

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia