Solved

Excel 2010 VBA - Question About Immediate Window

Posted on 2013-12-16
3
339 Views
Last Modified: 2013-12-16
I'm looking for my variables in the immediate window and I see one in the Comments section  and another in the Tab section.  
What is the logic behind the placement of variables in different locations?  This doesn't make sense (see graphics).

err
err2
0
Comment
Question by:brothertruffle880
  • 2
3 Comments
 
LVL 35

Accepted Solution

by:
[ fanpages ] earned 500 total points
Comment Utility
Hi,

...What is the logic behind the placement of variables in different locations?  This doesn't make sense (see graphics).

The Expression list is displayed in an ascending alphabetic order.

Hence, "CommissionAmt" & "TotalSales" appear in different locations in the list.

BFN,

fp.
0
 
LVL 83

Expert Comment

by:CodeCruiser
Comment Utility
Further to what is said above, these are not IN the Comments section or Tab section. These are below those two. Comments and Tab section have not been expanded.
0
 
LVL 35

Expert Comment

by:[ fanpages ]
Comment Utility
...Comments and Tab section have not been expanded.

Yes, I saw that from the image you provided.  I just thought you were mistaken.

The two variables, "CommissionAmt" & "TotalSales" must be defined (declared using a Dim statement, or similar) as variables within the module you are within when watching the 'Me' object.

Have I not answered your question already about the placement of the variables within the (sorted) list?
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now