+ Reply to Thread
Results 1 to 3 of 3

Display current contents of a variable and see how it changes when code runs?

  1. #1
    Registered User
    Join Date
    05-11-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    25

    Display current contents of a variable and see how it changes when code runs?

    Lets say I have a variable: ma
    When I step through my vba code, I want to see when variable ma changes and what the content is.
    Can I display the contents of a variable in a cell?
    Any help will be appreciated
    thanks
    Roger

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Display current contents of a variable and see how it changes when code runs?

    In the VBA editor, open the Locals window to see a list of your variables and their values. You can watch them change while you step through the code.

    VBA Menu: View\Locals

  3. #3
    Registered User
    Join Date
    05-11-2013
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Display current contents of a variable and see how it changes when code runs?

    Thanks AlphaFrog. Exactly what I wanted.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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