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.

Hi Shashi,

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

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

HTH

The user for will have a couple of events that will do what you wnat. There
is initialize which is the code which runs the first time the userform is
loaded. The second event is activate which is the code that is run each time
the userform is loaded. Add these event to the uer form (select them from the
drop down menus in the code for the userform) and add a message box to them
something like this...

Private Sub UserForm_Activate()
   MsgBox "Activate"
End Sub

Private Sub UserForm_Initialize()
   MsgBox "Initialize"
End Sub