Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 425
  • Last Modified:

Excel 2010 VBA - Question About Immediate Window

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
brothertruffle880
Asked:
brothertruffle880
  • 2
1 Solution
 
[ fanpages ]IT Services ConsultantCommented:
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
 
CodeCruiserCommented:
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
 
[ fanpages ]IT Services ConsultantCommented:
...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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now