MS-Excel |
| |
|
 |
What is Macros ? |
 |
How to Create Macro in Excel Sheet/environment. |
 |
How to Record and Execute Macros in Excel From Excel. |
 |
Introducing Visual Basic/Visual Basic Editors . |
 |
Introducing the Tools & Forms of VB. |
 |
Setting the Properties of a Controlls. |
 |
Introducing the Event of VB controlls. |
 |
Macro Creation/Design,Saving,Modification in Visual Basic. |
 |
How to Execute Macro of VB. |
 |
How to used the VB Controlls in Excel Sheets . |
 |
How to create the Link between Macros . |
| |
|
Visual Basic |
| |
Visual Basic is front end tool used to create forms through which user input can be accepted. It can take any type of Database Management system as Back end. |
| |
|
SALIENT FEATURES |
| |
|
 |
It has readymade tools which helps in creating user-friendly applications. |
|
Visual Basic forms can include components like label, text-area, combo box, list box, images etc. |
|
Event handling procedures are comparatively easier |
|
|