+ Reply to Thread
Results 1 to 4 of 4

Clearing the Intermediate Window in VBA

Hybrid View

CaptMac Clearing the Intermediate... 12-10-2017, 01:22 PM
YasserKhalil Re: Clearing the Intermediate... 12-10-2017, 02:32 PM
YasserKhalil Re: Clearing the Intermediate... 12-10-2017, 02:33 PM
CaptMac Re: Clearing the Intermediate... 12-11-2017, 01:27 AM
  1. #1
    Forum Contributor
    Join Date
    10-02-2008
    Location
    Berkeley, CA
    MS-Off Ver
    Windows 2007
    Posts
    105

    Re: Clearing the Intermediate Window in VBA

    Tried both of the previous posts. Didn't work. The "Code" one didn't clear the Intermediate
    window but also caused the running VBA program to reset back to programming level as well.

    The first solution as I mentioned in the original report didn't work unless there wa
    s a "Stop" command between the "SendKeys" line and the "Debug.Print" command.

    My solution was to put a "Stop" command into my "Debug_Print" routine. Then when I pressed
    the "Jump back to the calling program" key, I ended up at the line after the call in th
    e calling program.
     Sub Debug_Print(Message, _
                      Optional Short_Comment = "")
        ' IF Trace() Then clears the INTERMEDIATE Pane priot to _
          displaying "Message" and "Short_Comment""'.
        ' 12/10/17 Created. Mac Lingo
        
        Prog = "Debug_Print"
        
        If Trace() Then
        
            Application.SendKeys "^g ^a {DEL}"
            Stop
            
             If Short_Comment <> "" Then
                Debug.Print Short_Comment
                Debug.Print "===========================================" & _
                            "==================="
            End If
    
            Debug.Print Chr(10) & Message
            
            Debug.Print "===========================================" & _
                        "==================="
        End If
    Last edited by CaptMac; 12-11-2017 at 01:30 AM.

+ 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. Hi everyone, intermediate but gaining knowedge here.
    By simpdogg in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-13-2016, 06:11 AM
  2. Novice to Intermediate User Says Hello!
    By Skegeeace in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-07-2014, 12:57 PM
  3. Hi. Intermediate Mac Excel user here
    By gilroy0 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-28-2013, 05:52 AM
  4. [SOLVED] How to get an Intermediate value ?
    By thilag in forum Excel General
    Replies: 4
    Last Post: 01-27-2013, 09:25 AM
  5. Intermediate Excel Formula Help
    By BigChris10 in forum Excel General
    Replies: 3
    Last Post: 01-12-2011, 05:27 PM
  6. Searching for intermediate value
    By zapp7 in forum Excel General
    Replies: 5
    Last Post: 07-01-2008, 03:29 PM
  7. date returning time in vba intermediate window
    By papa jonah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-24-2005, 10:35 PM

Tags for this Thread

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