+ Reply to Thread
Results 1 to 7 of 7

How can I call a Module or a sub procedure and run it automatically in current module?

  1. #1
    Registered User
    Join Date
    08-07-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    87

    How can I call a Module or a sub procedure and run it automatically in current module?

    How can I call a existing Module or a sub procedure and run it automatically in current module?

    Thanks!

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: How can I call a Module or a sub procedure and run it automatically in current module?

    Please Login or Register  to view this content.
    as long as it's scoped right (not private)
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    08-07-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    87

    Re: How can I call a Module or a sub procedure and run it automatically in current module?

    Thanks!!
    But what about this one, I tried, however it doesn't work, why?
    Please Login or Register  to view this content.

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: How can I call a Module or a sub procedure and run it automatically in current module?

    because that's not what application.goto is for-it's for selecting ranges. it's a weird side effect that you can jump to procedure code that way

  5. #5
    Registered User
    Join Date
    08-07-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    87

    Re: How can I call a Module or a sub procedure and run it automatically in current module?

    Yes, it just jumps to procedure code without running it. what is it for?

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: How can I call a Module or a sub procedure and run it automatically in current module?

    Quote Originally Posted by JosephP View Post
    because that's not what application.goto is for-it's for selecting ranges.
    as mentioned :-)

  7. #7
    Registered User
    Join Date
    08-07-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    87

    Re: How can I call a Module or a sub procedure and run it automatically in current module?

    Got it! Thanks!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to use second procedure (the 2nd Sub) results in first procedure in the same module
    By lubbamkt in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-11-2014, 10:17 AM
  2. How to call a procedure from a different module, witihin "ThisWorkbook"
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-08-2012, 09:59 AM
  3. how to access Sheet module, normal module, Worbook module to type code
    By alibaba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2009, 07:51 AM
  4. get module line from erl and procedure
    By RB Smissaert in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-16-2006, 09:50 PM
  5. [SOLVED] Add Procedure To Module Via VBA
    By Al in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2005, 06:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1