Solved

Excel 2010 VBA - Question About Immediate Window

Posted on 2013-12-16
3
366 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
ID: 39721107
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
ID: 39721242
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 ]
ID: 39721360
...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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

806 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