Immediate Window Key Ins

[CementCarver]

I'm attempting to track down a problem in my code. I read on the internet that you can use the following keyin to help with problem indentification.



? ctl.Name
? ctl.ControlSource
? ctl.Enabled
? ctl.Locked
? ctl.Value

But I use these lines, the answers don't even relate to the variable or line of code where the code stops with a problem. They actually reflect a similar line farther up the module.

Am I using them correctly? Why don't they show results from where the code stopped?

CemenCarver

[amrut]

Use

Debug.print ctl.Name

just before the line where the code stops with the problem. See the result in immediate window.

[CementCarver]

Thanks Amrut... I'll give that a try.....CementCarver