View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Wiss Don Wiss is offline
external usenet poster
 
Posts: 300
Default Showing MsgBox after Control Toolbar macro runs

I have a combo box from the Control Toolbar on a sheet. It calls a Change
macro that is behind the sheet. After the macro runs (and does a lot of
writing to various sheets) I'd like to display a warning message under
certain circumstances. The MsgBox beeps, but does not display. If I put a
stop before it and step through the code, then it displays. Also if I put a
dummy MsgBox "" first, then the second one that I want does display. But
I'd rather not do this kludge.

Don <www.donwiss.com (e-mail link at home page bottom).