ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Debug window displays for no reason (https://www.excelbanter.com/excel-programming/398766-debug-window-displays-no-reason.html)

Keith74

Debug window displays for no reason
 
Hi All

I've got a problem on one users pc. For some reason the code stops on
the line

txtBudgetAgreed.Value = ADORecordset!BudgetAgreed

This line works fine on other PCs and when this user goes into debug
mode you can still step through the code without getting an error. At
the time of execution the textbox has a value of 0.00 and the
recordset has a value of 0.

Any ideas?

Thanks

Keith


Piotr Zaniewski

Debug window displays for no reason
 
On Oct 5, 11:39 am, Keith74 wrote:
Hi All

I've got a problem on one users pc. For some reason the code stops on
the line

txtBudgetAgreed.Value = ADORecordset!BudgetAgreed

This line works fine on other PCs and when this user goes into debug
mode you can still step through the code without getting an error. At
the time of execution the textbox has a value of 0.00 and the
recordset has a value of 0.

Any ideas?

Thanks

Keith


Hi Keith,

Check if in OptionsGeneral in Error trapping section you selected
"Break on unhandled errors". Second idea is that when you add wath to
the variable you can select option "Break when value is true (for
boolean variables) and break when value changes", make sure that only
"watch expression option" is selected.

Hope it helps,

rgds
Piotr



All times are GMT +1. The time now is 02:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com