Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error location in VBA
Hi!
I have a few users who work with an Excel Addin I created. For security purposes I have Password-Locked the project so the users can't access the code. However, an error arises now and then, and It's hard for me to debug sometimes because I can't tell where the error occured. I would like it if when an error arises, insted of showing the "Run-Time error" dialog, it shows a msgbox displaying a custom message and the location of the error (Module / Line), but still without opening access to the project itself. Is this possible? Any suggestions greatly appreciated. Best regards, Albert C. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error location in VBA
Forgot to mention.
I know about "Erl", but it only works if you have your code line-numbered. Is there a way to display de line # displayed on the vb editor's Standard Toolbar? Thanks in advance. "Albert" wrote: Hi! I have a few users who work with an Excel Addin I created. For security purposes I have Password-Locked the project so the users can't access the code. However, an error arises now and then, and It's hard for me to debug sometimes because I can't tell where the error occured. I would like it if when an error arises, insted of showing the "Run-Time error" dialog, it shows a msgbox displaying a custom message and the location of the error (Module / Line), but still without opening access to the project itself. Is this possible? Any suggestions greatly appreciated. Best regards, Albert C. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error location in VBA
You can use SUMPRODUCT() to sum
To sum c based on conditions in A and B =SUMPRODUCT(--(A1:A10=D1),--(B1:B10=D2),C1:C10) If this post helps click Yes --------------- Jacob Skaria "Albert" wrote: Hi! I have a few users who work with an Excel Addin I created. For security purposes I have Password-Locked the project so the users can't access the code. However, an error arises now and then, and It's hard for me to debug sometimes because I can't tell where the error occured. I would like it if when an error arises, insted of showing the "Run-Time error" dialog, it shows a msgbox displaying a custom message and the location of the error (Module / Line), but still without opening access to the project itself. Is this possible? Any suggestions greatly appreciated. Best regards, Albert C. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error location in VBA
Please ignore the below post which was meant for another thread
"Jacob Skaria" wrote: You can use SUMPRODUCT() to sum To sum c based on conditions in A and B =SUMPRODUCT(--(A1:A10=D1),--(B1:B10=D2),C1:C10) If this post helps click Yes --------------- Jacob Skaria "Albert" wrote: Hi! I have a few users who work with an Excel Addin I created. For security purposes I have Password-Locked the project so the users can't access the code. However, an error arises now and then, and It's hard for me to debug sometimes because I can't tell where the error occured. I would like it if when an error arises, insted of showing the "Run-Time error" dialog, it shows a msgbox displaying a custom message and the location of the error (Module / Line), but still without opening access to the project itself. Is this possible? Any suggestions greatly appreciated. Best regards, Albert C. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error location in VBA
There is nothing native in VBA to include line numbers. However, I
believe that MZTools will do this for you. Google for MZTools. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 12 Aug 2009 10:34:01 -0700, Albert wrote: Forgot to mention. I know about "Erl", but it only works if you have your code line-numbered. Is there a way to display de line # displayed on the vb editor's Standard Toolbar? Thanks in advance. "Albert" wrote: Hi! I have a few users who work with an Excel Addin I created. For security purposes I have Password-Locked the project so the users can't access the code. However, an error arises now and then, and It's hard for me to debug sometimes because I can't tell where the error occured. I would like it if when an error arises, insted of showing the "Run-Time error" dialog, it shows a msgbox displaying a custom message and the location of the error (Module / Line), but still without opening access to the project itself. Is this possible? Any suggestions greatly appreciated. Best regards, Albert C. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
source location and error message 400 | Excel Programming | |||
Changed location of Add-In file--can't be found error | Excel Programming | |||
Execution Error due to file location | Excel Programming | |||
Button Error - Save at location | Excel Programming |