View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter Rooney Peter Rooney is offline
external usenet poster
 
Posts: 325
Default MSGBOX not working

Norman,
I sorted it - I had a SendKeys command that was supposed to send some
{Enter}s to suppress warning messages - unfortunately, whilst they were used
in the application from whiuch i copied the code, they weren't needed in this
one - hence the MsgBox es effectively had their "OK" buttons clicked, so
didn't appear to appear (if you see what I mean)
That'll teach me to take a break more often in the afternoon! :-)
Thanks for your time
Pete

"Norman Jones" wrote:

Hi Peter,

Try putting a breakpoint at the first msgbox and when the code stops, use
the immediate window to check the condition which should trigger the
display. This will also verify that the relevant line is not being bypassed
due to earlier branch in the code - do you have an error handler for
example?


---
Regards,
Norman



"Peter Rooney" wrote in message
...
Good afternoon, all,

Has anyone ever come across instances of MSGBOX not displaying, even when
it's obvious that the code is processing the command?
I'm using MSGBOXes to debug some code - some of them work and some of them
don't, thought they all should, as the code goes past them all.
Any thoughts?
Thanks in advance
Pete