Use the Initialize event...

Private Sub UserForm_Initialize()
Call Macro1
End Sub

--
Rick (MVP - Excel)


"jason" wrote in message
...
basically


sub userform_open()

call macro1

end sub


this is not correct but demonstrates what i am attempting to accomplish