call stack

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Call Stack

Call Stack

resolvedResolved · Low Priority · Version 2003

Stephen has attended:
MOS Exam course
Visio Advanced course
Excel VBA Advanced course
Upgrade to Office 2007 course
PowerPoint Intermediate Advanced course

Call Stack

I was wondering what the Call Stack (from the View option in the VBE main menu) is used for. I couldn't find anything seaching VBE help.

Thanks

RE: Call Stack

Hi Stephen

Thank you for your question

The call stack window is available when the code breaks, due either to an error or through code breaking by the operator.

It simply shows the module that called the breakpoint. It is a useful debugging tool for complex projects

Hope this is useful

Regards

Stephen


 

Excel tip:

Calculate age or service

The DATEDIF() function in Excel calculates the number of days, months, or years between two dates. So, this function makes it easy to calculate a person's age. To try this tip:

In a blank worksheet, type the birth date in cell A1, using slashes to separate day, month, and year.
In cell A2, type =DATEDIF(A1,TODAY(),"y") and press ENTER.

View all Excel hints and tips


Server loaded in 0.07 secs.