Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Mar 2002
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    UserForm Parameters ?? (97 sr2)

    Is there anyway to pass parameters to a Load.Userform so that the Initialize routine will behave differently? <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,820
    Thanks
    133
    Thanked 481 Times in 458 Posts

    Re: UserForm Parameters ?? (97 sr2)

    In the Form activate event routine you could fetch some data from some prenamed cells and then test the contents.

    zeddy

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: UserForm Parameters ?? (97 sr2)

    The Initializate routine itself doesn't take parameters, but in it you can
    <UL><LI>Read values from cells in worksheets
    <LI>Use the values of global variables[/list]With these, you can
    <UL><LI>Fill controls on the userform
    <LI>Take decisions, e.g. show or hide some controls
    <LI>Call subroutines or functions that take these values as parameters
    <LI>... (use your imagination)[/list]

  4. #4
    Lounger
    Join Date
    Mar 2002
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: UserForm Parameters ?? (97 sr2)

    Thanks folks...

    Pretty much what I had in mind but I just had to ask if there was a more "correct" way to do this.

    <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

Posting Permissions

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