Friday, August 6, 2010

Visual Basic, Macro and Excel

Example 1:
1. Open Visual Basic Editor by go to Tools...Macro...Visual Basic Editor or just simply press the [Alt] and [F11] keys at the same time.
2. In the Insert menu on top of the Visual Basic Editor, select Module to open the Module window (code window).
3.In the Module window, type the following:


Sub showMessage()
MsgBox "Hello World!"
End Sub

4. Click the Run button,, press [F5], or go to Run..Run Sub/UserForm to run the program


5. The message box pops up with the "Hello World!" greeting.

No comments:

Post a Comment