VBA MS

CRISP-DM Datamining Phases

2008-08-24T03:10:00.000-07:00

CRISP-DM is widely know industry standard for Data Mining.
Learn more about CRISP-DM in my Article
(Data Mining Phases).

Cheers.
Mandeep Singh

First VBA Example

2008-08-18T06:15:00.000-07:00

Hi everyone

This time you i will help you to write your first VBA code in Excel. Use following steps.
1. Open Excel.
2. Go to View>toolbar>visual basic
3. Click on control toolbox( on the visual basci toolbar)
4. Click on Command Button( move mouse accross the different icons to view the name of
different objects).
5. Place it on the Excel sheet.
6. Double click on the command button.
7. Place following code there.
Range("a1").Select
Range("a1").Value = "Welcome to VBA MS Blog"
8. Now you code will look like this:

Private Sub CommandButton1_Click()

Range("a1").Select
Range("a1").Value = "Welcome to VBA MS Blog"

End Sub

9. Go back to excel window.
10. Click exit design button on the Visual Basic Toolbar.
11. No Click the Button and see "Welcom to VBA MS Blog" in A1 Address.

You can post your comments about this example. You can also ask questions and example(VBA).

Mandeep Singh

VBA

2008-08-16T20:44:00.000-07:00

VBA (Visual Basic for Application) is powerful language used to automate MS Office Application. According to my experience VBA is mostly used to automate MS-Excel and MS-Access as compare to other office application. No one can realize the power of VBA. Every day there are many different examples of VBA written by the VBA programmers all over the world.

In next blog i will show you some simple example of VBA code. If VBA is new concept for you, you can go on google and find more about VBA Programming.

Mandeep Singh