View original (French)

Call a VBA module

Solved
dubolg -  
 dubol -
Hello,

Small programming issue.

I wrote a code in a module (Sub ex1 () )

I want to call the "Sub ex1" in another module (Sub_principal) and have it execute only once

Can you help me? Thank you

Have a nice day

8 answers

  1.
    chossette9 Posted messages 6855 Registration date   Status Contributor Last intervention   1 313
     
    Hello,

    you just need to write ex1 or Call ex1 in the main routine.

    Example: 
    Sub Sub_principal() ... Call ex1 ... End Sub


    Best regards.
    --
    This guy wasn't the brightest, as he was naive.
    7
  2. cousinhub29 Posted messages 1114 Registration date   Status Member Last intervention   381
     
    Good evening;

    Would you happen to have a module name called "ex1", by any chance?

    You can't name a Sub and a Module the same name....

    Have a good evening.
    3
  3. dubol
     
    Hello,

    To present my problem that is still not resolved.

    In Microsoft Visual Basic under Excel,

    I created 3 macros (starting with Sub... and ending with End Sub) in the module folder. In this same folder, I created a 4th one that I will call main, in which I would like to call the 3 macros (to execute them).

    Thank you for your help.
    1
    1. pijaku Posted messages 13513 Registration date   Status Moderator Last intervention   2 773
       
      Hello,
      If your VBA code is not "top-secret", I invite you, for a definitive and quick solution, to copy/paste the codes of the three procedures (I created 3 macros starting with Sub... and ending with End Sub) right here in a response. You'll see, you'll have your solution by the end of the day...
      0
    2. dubol
       
      It's not the content that matters, but the way of calling the procedures.

      I'm on the path to resolution, I'll keep you updated.
      0
  4. dubol
     
    In fact, I have in the module properties (name) named the same name as the one in the module at the Sub level...

    Since I changed to different names, I can now call my procedures.
    1
  7. dubolg
     
    I already tried, the other problem is that it tells me "variable or procedure expected, not module".
    0
  8. Le Pingou Posted messages 12276 Registration date   Status Contributor Last intervention   1 478
     
    Hello,
    Just passing by, at what time did you receive this message?
    --
    Regards.
    The Penguin
    0
  9. dubolg
     
    It's when I run my program (sub main()) in step-by-step mode.

    Shouldn't the variables of sub ex1() be declared in the main?
    0
    1. Le Pingou Posted messages 12276 Registration date   Status Contributor Last intervention   1 478
       
      Hello,
      If at the beginning of the module you have the instruction line [Option Explicit], you must declare the variables.
      Regards.
      The Penguin
      0