+ Reply to Thread
Results 1 to 5 of 5

Event when a user form is loaded

  1. #1
    Registered User
    Join Date
    02-02-2006
    Posts
    12

    Event when a user form is loaded

    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

  2. #2
    Lonnie M.
    Guest

    Re: Event when a user form is loaded

    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



  3. #3
    Zack Barresse
    Guest

    Re: Event when a user form is loaded

    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" <shashi1515.25e4kh_1143567346.4808@excelforum-nospam.com> wrote
    in message news:shashi1515.25e4kh_1143567346.4808@excelforum-nospam.com...
    >
    > 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
    >




  4. #4
    Jim Thomlinson
    Guest

    RE: Event when a user form is loaded

    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
    --
    HTH...

    Jim Thomlinson


    "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
    >
    >


  5. #5
    Registered User
    Join Date
    02-02-2006
    Posts
    12
    Thank you all for your replies. I got it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1