Saturday, June 20, 2009

String Handling Functions-InStr

The InStr function looks for a phrase that is embedded within the original phrase and returns the starting position of the embedded phrase. The format is

Instr (n, original phase, embedded phrase)

Where n is the position where the Instr function will begin to look for the embedded phrase.

For example

Instr(1, “Visual Basic”,” Basic”)=8

Wednesday, June 10, 2009

New Book Release! Title: Excel VBA Made Easy

New Book Release!

I have just published another e-book today. The title is "Excel VBA Made Easy- A Concise Guide for Beginners". This book is written for the benefits of readers who are keen to master Excel VBA in a short time. It is written in plain English so everyone should find it easy to understand. Plenty of examples are presented in the book. It is a must-have Excel VBA guide book for beginners and even intermediate learners!

Please go to the link below to download the book, it is selling at $15.00

Monday, June 1, 2009

Check Box

HTML clipboard

The Check Box control lets the user selects or unselects an option. When the Check Box is checked, its value is set to 1 and when it is unchecked, the value is set to 0. You can include the statements Check1.Value=1 to mark the Check Box and Check1.Value=0 to unmark the Check Box, as well as use them to initiate certain actions. For example, the program will change the background color of the form to red when the check box is unchecked and it will change to blue when the check box is checked.

Example 3.4

Private Sub Command1_Click()

If Check1.Value = 1 And Check2.Value = 0 Then
MsgBox "Apple is selected"
ElseIf Check2.Value = 1 And Check1.Value = 0 Then
MsgBox "Orange is selected"
MsgBox "All are selected"
End If

End Sub