If I understand your question correctly, you can use the UserForm's
Initialize event to do that.

Rick


"Patrick Kirk" wrote in message
...
I have a userform with a listbox. The listbox displays a string from
another
function. Is there a way to run the function code once the userform
becomes
visible or open? Im not able to find a open event. Any help will be
appreciated.
--
PK