+ 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. 08-29-2014, 11:14 AM #1
    qzqzjcjp
    qzqzjcjp is offline
    Registered User
    Join Date
    08-07-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    95

    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!
    Reply With QuoteRegister To Reply
  2. 08-29-2014, 11:16 AM #2
    JosephP
    JosephP is offline
    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
    Reply With QuoteRegister To Reply
  3. 08-29-2014, 11:28 AM #3
    qzqzjcjp
    qzqzjcjp is offline
    Registered User
    Join Date
    08-07-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    95

    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.
    Reply With QuoteRegister To Reply
  4. 08-29-2014, 11:34 AM #4
    JosephP
    JosephP is offline
    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
    Reply With QuoteRegister To Reply
  5. 08-29-2014, 11:43 AM #5
    qzqzjcjp
    qzqzjcjp is offline
    Registered User
    Join Date
    08-07-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    95

    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?
    Reply With QuoteRegister To Reply
  6. 08-29-2014, 11:45 AM #6
    JosephP
    JosephP is offline
    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 :-)
    Reply With QuoteRegister To Reply
  7. 08-29-2014, 11:48 AM #7
    qzqzjcjp
    qzqzjcjp is offline
    Registered User
    Join Date
    08-07-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    95

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

    Got it! Thanks!!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1