View Full Version : defining and handling of parameters

03-17-2005, 03:55 AM
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()).

03-17-2005, 05:03 AM
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.