Hi,
have the various procedures that initialize the form pass to your
userform initialize code something you can use to test it--something
like:
'Public myTest as boolean
If myTest1 = True then UserForm1.TextBox1.Enabled = True

HTH--Lonnie M.

shashi1515 wrote:
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