Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-17-2011, 02:46 PM
davids67 davids67 is offline excel where is procedure being called from Windows XP excel where is procedure being called from Office 2007
Novice
excel where is procedure being called from
 
Join Date: Nov 2011
Posts: 3
davids67 is on a distinguished road
Default excel where is procedure being called from

Hi all



silly question

is there a way I can find out whereabouts in the workbook VBA procedure is actually being called from.

I am looking at some VBA code and I want to know where the procedure is being called from.

many thanks

D
Reply With Quote
  #2  
Old 11-18-2011, 06:48 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline excel where is procedure being called from Windows 7 32bit excel where is procedure being called from Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

Hi,

There isn't a built-in tool to do this at design time. I use a free piece of software called MZ Tools to do this.

If you want to do it at runtime then you can set a breakpoint and then view the Call Stack (CTRL+L).
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel where is procedure being called from What is this symbol called as? Franky Word 3 11-12-2011 08:16 AM
Document selection procedure kennethc Word 0 09-15-2010 02:56 PM
What is this right-click sub-menu called? wornways Word 3 08-13-2010 09:17 PM
excel where is procedure being called from Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM
Sub Procedure for File Save As PDF or XPS menu option gsbakshi Word VBA 0 02-19-2010 12:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft