T
tkt_tang
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.
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.