View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
T. Erkson T. Erkson is offline
external usenet poster
 
Posts: 11
Default How to jump from a Form procedure to a Workbook or Module procedure?

I have a procedure in a user form and I need to have it execute a procedure in a
worksheet module (same workbook). Basically I need to "Call mySubroutine()"
from a form to an outside subroutine. How do you do that? Even a "GoTo xxx"
would be fine.

I looked at Chip P's site and using his "Programming To The Visual Basic Editor"
(http://www.cpearson.com/excel/vbe.htm) I can programmatically find the
procedure in the correct module and what line it begins on... if it even
matters.

Thanks,

Toby Erkson -- Portland, Oregon -- http://www.bidata.net/