Results 1 to 3 of 3

Thread: [RESOLVED] Run Sub created in Form1 from Form2

  1. Mar 17th, 2009, 08:50 AM #1
    snjdev
    snjdev is offline

    Thread Starter
    Junior Member
    Join Date
    Mar 2009
    Posts
    18

    Resolved [RESOLVED] Run Sub created in Form1 from Form2

    I am in the process of creating an excel add-in.
    I have created a subroutine inside one form. Using a second form, I would like to run the subrountine if the "OK" button is clicked.
    How do I make this public subroutine availiable between forms?

    Sorry if this is a stupid question. I am new at this and I have been given this project with very little instruction. Trial by fire.

    Thanks,
    snjdev
    Reply With Quote Reply With Quote
  2. Mar 17th, 2009, 08:54 AM #2
    AnthonyGrimes
    AnthonyGrimes is offline
    Addicted Member AnthonyGrimes's Avatar
    Join Date
    Sep 2008
    Location
    United States
    Posts
    131

    Re: Run Sub created in Form1 from Form2

    You could put the subroutine in a module.
    Reply With Quote Reply With Quote
  3. Mar 17th, 2009, 10:05 AM #3
    Shaggy Hiker
    Shaggy Hiker is offline
    Super Moderator Shaggy Hiker's Avatar
    Join Date
    Aug 2002
    Location
    Idaho
    Posts
    40,106

    Re: Run Sub created in Form1 from Form2

    If the routine is declared public, and the instance of the form with the routine is within scope of the form that calls the routine (that's a BIG if), then the call would be:

    <instance of form>.<method name>

    as would be the case for any other public member of any other class. Forms are just classes.
    My usual boring signature: Nothing
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width