VB and VBA Users Source Code: Test if the VB IDE is running

VB/VBA Source Code
Test if the VB IDE is running

By:	Andrew Baker
Email (spam proof):	Email the originator of this post
Date:	Thursday, December 07, 2000
Hits:	474
Category:	Visual Basic General

Article:
It is often useful to test if the code is being run from the IDE or a compiled application. To test this use the following function: 'Purpose : Tests if the VB IDE is running 'Inputs : N/A 'Outputs : Returns True if the IDE is running 'Author : Andrew Baker 'Date : 07/12/2000 11:55 'Notes : Since the Debug.Print line will be removed in the compiled application ' the code will execute instantly without error. 'Revisions : 'Assumptions : Function IDERunning() As Boolean On Error GoTo IDERunning Debug.Print 1 / 0 Exit Function IDERunning: On Error GoTo 0 IDERunning = True End Function
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder