In general, how can I execute one subroutine from inside another subroutine?

Thanks for all help!

However, since the code is going to be *shared*, then you would increase
its elegance by putting it in its *own* procedure, which is then called
by both the original event handler and your other routine.

--
Paul Bredbury, http://dialspace.dial.pipex.com/brebs/

If you are calling it from a procedure outside the form, you would
need to make the click event procedure Public and use:
Form_MyForm.MyButton_Click

If you want to call an event procedure that has parameters (like
BeforeUpdate) you need to pass in a valid value for the parameter(s).

 -- Andy

Thank you very much for the help!!

Would you explain more what you mean where you talk about parameters in
event procedures. What kind of parameters? Could you give me some details?

Thank you.

'---------------------------------------------

Private Sub opt1999_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)

    'the code goes here ....

end sub

'---------------------------------------------

Here is "Cancel" a parameter of type "MSForms.ReturnBoolean", and you can
refer to it in your code within the event-procedure "opt1999_BeforeUpdate".

To call this routine from a sub:

'---------------------------------------------

Private sub Something()

    opt1999_BeforeUpdate False

end sub

'---------------------------------------------

Here we passed the value "False" to the variable "Cancel" in the
event-procedure "opt1999_BeforeUpdate".

Hope this helps!

Regards,

Oddbjorn Bersas