+ Reply to Thread
Results 1 to 5 of 5

Seeing Gloabal (Array) in Debug Mode?

  1. #1
    Registered User
    Join Date
    10-02-2017
    Location
    Huntsville, Alabama
    MS-Off Ver
    2010
    Posts
    57

    Seeing Gloabal (Array) in Debug Mode?

    I've got a user-type array set up and populated in a code module other than where I'm stepping through code to debug.

    The arrays are Global (on top of the code).

    Where I'm stepping, I've tried setting up a watch (they don't show up in the Local window pull-down) as;

    myInfo
    myInfo()
    Module30.myInfo
    Module30.myInfo()
    ...

    Is there a way to view an in-scope variable that doesn't reside where the code is currently running/stopped/single-stepped in debugging modes?

    At present, the only way I've had to review data is debug.print or moving the array around to where the code is running (annoying!)...

    ==========

    Also got another (unrelated) issue --- crashes if I don't close and reopen the workbook after running some code and userforms ... anybody know of a utility to export then import all the modules and userforms to a new workbook? I've got some 40 odd to do and don't want to try it manually (I've read that extensive modules/editing in VBA can cause this issue)

    TIA
    Grug

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Seeing Gloabal (Array) in Debug Mode?

    For the first part
    Right click the variable name > Add Watch > OK

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Seeing Gloabal (Array) in Debug Mode?

    anybody know of a utility to export then import all the modules
    AppsPro CodeCleaner
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Registered User
    Join Date
    10-02-2017
    Location
    Huntsville, Alabama
    MS-Off Ver
    2010
    Posts
    57

    Re: Seeing Gloabal (Array) in Debug Mode?

    Thanks @Fluff13/@shg!!!

    Batting 1000 on both accounts, right-click also showed the defaults with the dialog box (maybe can do it on the keyboard...), and have downloaded the cleaner app, but will have to run permission to use through IT Dept.

    Much appreciated

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,080

    Re: Seeing Gloabal (Array) in Debug Mode?

    Glad we could help & thanks for the feedback

+ 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] VBA code works in debug mode but misses steps running in normal mode
    By supereeg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2016, 05:42 AM
  2. VBA AutoFilter does not Work in run mode, only in debug mode
    By aganove in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 11-19-2015, 04:32 PM
  3. [SOLVED] Code runs in debug mode only.
    By Kramxel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-20-2015, 10:42 AM
  4. VBA Code Runs in Debug Mode But Returns Type Mismatch Error Outside Debug Mode
    By valerie.k.chiang in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2014, 03:48 PM
  5. [SOLVED] Code skips on Run Mode but runs fine on F8 (Debug Mode)
    By RaquelAR in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-25-2013, 01:05 PM
  6. Get in DEBUG mode on workbook open
    By Anthony Fok in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-28-2005, 01:30 PM
  7. Strange Excel behaviour in debug mode
    By valk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2005, 06:56 AM

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