Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a pop-up window that displays a range in Excel?? | Excel Worksheet Functions | |||
UDF Works in Debug Window but not on Sheet? | Excel Programming | |||
customizing debug pop up window | Excel Discussion (Misc queries) | |||
VB Window automatically displays | Excel Programming | |||
Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions |