Hi Shashi,

You can use the userform_initialize event in your userform code window ...

Private Sub Userform_Initialize()
'your code here..
End Sub

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"shashi1515" wrote
in message ...

I am using Excel 2000 and I want some event to triger whenever my user
form is loaded.

Ex: I have a user form with 6 edit boxes and I want to enable only few
edit boxes depending on the situation at which the user form is
called.

How should I capture the event the user form is loaded. Please help.

Thanks,
Shashi


--
shashi1515
------------------------------------------------------------------------
shashi1515's Profile:
http://www.excelforum.com/member.php...o&userid=31109
View this thread: http://www.excelforum.com/showthread...hreadid=527224