Consulting

Results 1 to 2 of 2

Thread: defining and handling of parameters

  1. #1

    defining and handling of parameters

    I have another question, is it possible to define a parameter in 1 sub (say in the sub userform_activate()) and then in the next sub (which always follows after the activate sub) recall this parameter by it's name given in the first sub. And the sub i want to recall the parameter is also an event sub (box_change()).

  2. #2
    VBAX Master Killian's Avatar
    Joined
    Nov 2004
    Location
    London
    Posts
    1,132
    Location
    Yes, this is described as variable scope which you should read up on to understand fully
    basically, if you declare the variable at the start of the module it will be 'visible' to all the other routines in that module. If you declare it as Public, it will be visible to the whole project.
    K :-)

Posting Permissions

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