How can we use Visual Basic language for excel tutorials?

Microsoft Excel2010 is an extremely powerful tool that you can use to manipulate, analyze, and present data.
Sometimes though, despite the rich set of features in the standard Excel user interface (UI), you might want to find an easier way to perform a mundane, repetitive task, or to perform some task that the UI does not seem to address.
Fortunately, Office applications like Excel have Visual Basic for Applications (VBA), a programming language that gives you the ability to extend those applications.

If you want to create an Excel workbook with built-in tutorial, VBA can be used to provide on-topic help texts.

 

On several occacions I built "help buttons" into the Excel workbook. When klicked an on-topic help text appears, giving instructions or examples. Even external documents, like .pdf or Word files can be linked.

 

Those kind of scripts are very small and easy to make. An example:

 

Sub HelpButton()    Response = MsgBox("This is the built-in help text, explaining the functionality of the Excel Workbook you are working on.",0, "Tutorial")End Sub

 

First step is to enable the Develop tab: * Go to FILE>OPTIONS>EXCEL OPTIONS, * Click CUSTOMIZE RIBBON * Under CHOOSE COMMANDS FROM and select POPULAR COMMANDS * Under CUSTOMIZE THE RIBBON, select MAIN TABS then click OK After Excel displays the Developer Tab you can start making macros.
Macros are step-by-step procedures coded in Visual Basic.
If you know how to code in VB, you will not have a hard time.
There are a lot of resources for books in the net (paid and free), you can also check video tutorial from Lynda.