Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 120
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make a pop-up window that displays a range in Excel?? tyler.speer Excel Worksheet Functions 1 January 19th 07 01:22 AM
UDF Works in Debug Window but not on Sheet? Andibevan Excel Programming 2 September 26th 06 11:42 AM
customizing debug pop up window tx12345 Excel Discussion (Misc queries) 0 August 22nd 06 11:39 PM
VB Window automatically displays JT Excel Programming 1 August 1st 06 05:46 PM
Formula window displays correct answer while cell displays incorre MMV Excel Worksheet Functions 3 November 10th 04 09:28 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"