View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Excel Chemistry Before and After

I think you may be oversimplifying.
It's not clear for example what is triggering any of the code you show ?

If the second message does not show then either that code is not being
called, or somewhere you have an error handler which is catching something
silently.

Tim



wrote in message
...
Mr. Tim Williams,

When the code runs,

MsgBox "Sub ComBox_Change() ...... Exit Sub."

would show the typical dialog box on-the-screen.

And then, there is nothing and just nothing to show for,

With ButtonTopLeftCell
.Columns.AutoFit
MsgBox "Cell Breadth = " & .ColumnWidth
End With

(Although it was there when the workbook opened in the first jiffy).

If everything (subsequently) would just run like that first jiffy,
there should be no more problem. But, that's not the situation
altogether.

Admittedly, the query case has been simplified a bit (to avoid over-
clouding the case unnecessarily).

Regards.