+ Reply to Thread
Results 1 to 2 of 2

Call Macro from Private Sub

  1. #1
    Registered User
    Join Date
    06-19-2015
    Location
    Los Angeles, California
    MS-Off Ver
    2013
    Posts
    13

    Call Macro from Private Sub

    So here is the code I am using as a Private Sub on Sheet 2. When a cell in G equals Confirmed the cell in U in the same row gets time stamped. The code works like a charm, but I want to add to it and be able to call another macro into it when G equals confirmed. Can this even be done? I have tried adding the call command to the code below and have tried adding a 2nd Private Sub to call the macro but it never works. Any help would be great!

    Please Login or Register  to view this content.
    Here is one of the variations I tried. Don't laugh to hard.

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    09-03-2015
    Location
    IE
    MS-Off Ver
    2003 - 2016
    Posts
    258

    Re: Call Macro from Private Sub

    As long as Macro2 is in scope, it should work... are you sure it's not erroring and just continuing?

    Read the link first and if you're sure Macro2 is in scope, try changing your error handler to report errors, temporarily.

    Please Login or Register  to view this content.

    End Sub

+ 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. hw we call a private macro in other sheet from module1
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2014, 01:57 PM
  2. [SOLVED] Call Private Sub Routine From Main Macro
    By timbo1957 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2013, 04:50 AM
  3. Call private sub with variable in its name
    By Willardio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2013, 11:56 AM
  4. Call Private Sub from Add-In
    By Vaw08 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2013, 02:33 PM
  5. call private sub from module
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2009, 10:02 AM
  6. how to call a Private Sub ?
    By dpenny in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2007, 01:15 PM
  7. IF Statements-call private sub
    By CrimsonPlague29 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-11-2006, 12:00 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