Going into advance excel with VB

Asked By Kyle Harrison 0 points N/A Posted on - 04/07/2012

I am interested in learning VBA.  

I've been using macros for a while now in Excel, but I don't know how to edit macros in the VBA window.  

Is this kind of programming something that I should learn in order to advance in using macros with Excel?  

• Status: Open
• Question Views: 1084
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Visual basic

Answered By Hathy Carla 0 points N/A #109872

Going into advance excel with VB

Visual Basic for Application (VBA) is a scripting language behind Microsoft Excel macros. The basic use of VBA and macros in MS  Excel is through macros recording, which the codes are automatically generated based on the actions and manipulation of the user, recorded as a macro. For example, when the user record a macro for adjusting the width of column A, the code generated is:

Sub Macro1()

    Columns("A:A").ColumnWidth = 14.43

End Sub

Obviously, the programming language used in Excel macros is BASIC, specifically Visual Basic. A knowledge in Visual Basic is a plus.

However, studying and experimenting with the generated code is not difficult and will help you learn easily. An object browser in the VBA window let's you browse the available members, properties and methods of a certain component that are available to use in composing macros with VBA codes. Press F2 in the VBA window to open the object browser.

About Hathy Carla

Questions
0

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/24/2012
• Question Category: Visual basic