Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel Chemistry Before and After
Re : Excel VBA-Chemistry Before and After ......
1. Enter an Excel worksheet and the VBA module thereof. 2. The VBA used to run OK ; and then, it began to behave as follows ...... 3. When the WorkBook opens (in the first instant), the VBA would print the following statements on the screen, namely, A. MsgBox "Sub ComBox_Change() ...... Exit Sub." B. With ButtonTopLeftCell .Columns.AutoFit MsgBox "Cell Breadth = " & .ColumnWidth End With 4. However, on subsequent run, it would print statement-A only. Statement-B is ignored 5. In fact, it means that it would print character-string exclusively. MsgBox with variable is ignored. 6. Please comment and share your experience. 7. This is Excel-2000. 8. Regards. |