What is a excel VBA -2147467259 then?
A macro is simply a set of instructions given in Excel VBA.
Writing your first macro
Note: If you are new to computer programming, see our introductory video programming before continuing excel VBA -2147467259.
To write your first VBA program (or macro), you need to know the language first. This is where the tape will help Excel.
Everyone has a language. My mother tongue is Tel excel VBA -2147467259. But I also speak Hindi, English and Cutis ( this is the language of my 2 year old children talk ). You can be comfortable in English, Spanish, French, German and Vietnamese.
Like you and I, Excel also has language that excel VBA -2147467259 he can speak and understand. This language is called VBA (Visual Basic for Applications ).
When instructions say to excel in this VBA , Excel can do what you say . This allows you to program Excel so that you can automate a boring report, format a big ugly tablt, some disorder data cleansing or just play excel VBA -2147467259 random noise.
Tape ?
Yes Excel has a built recorder, listen and record everything you do, in your own language Excel excel VBA -2147467259, VBA say.
Since we do not know any VBA, we will use this device to record our actions, then we will see the recorded instructions (called code in computer jargon ) seems to understand how VBA .
Our First VBA macro - excel VBA -2147467259 Malingered ()
Now that you understand some VBA jargon can make and write our first VBA macro. The goal is simple. When you run this macro, bring color to the currently selected cell with red. Why red? Oh, red is nice, bright and modern excel VBA -2147467259 - just like you.
Understanding the VBA code Malingered.
Let's go through the entire macro code one line at a time.
Under Malingered (): This line tells Excel that a new set of instructions is written. SUB The word indicates that the following lines of VBA are a sub - procedure (excel VBA -2147467259) . Computer jargon means a group of related instructions to stay together to do something meaningful. Sub - procedure ends when Excel sees the phrase "End Sub"
Lines beginning with an apostrophe: These lines are comments. Excel ignores what you type after an apostrophe. These are for your understanding.
Excel Color = 192 is said to fill red color in the excel VBA -2147467259 selected cell.
End With : This marks the end of the With block.
End Sub This is the end of our little macro named Malingered ().
Some tips for a better understanding of this macro:
Once you look at the macro code, here are some ways to get better.
With excel VBA -2147467259 Selection.Interior: When filling a cell with red may seem a little for you and me, is actually a lot of steps for your computer. And every time I have to do a lot of operations on the same thing (in this case, the selected cell ) , best of all is the group. This is where the WITH statement comes in the picture. When Excel sees With Seletion.Interior ,excel VBA -2147467259 will think ,Well , I'll make all future transactions within the selected cell until you see the finish line
Lines beginning with. These are lines corresponding to the Excel format within the cell. In this case, the line is the largest..
Change something, you can change excel VBA -2147467259 almost any line of the macro to see what happens. For example, change. Color = 192 . Color = 62 and save . Then return to Excel and run the macro to see what happens.
Quite something, you can delete certain lines of the macro to see what happens. Delete the line . Watercolor = plutocratic and excel VBA -2147467259 run again to see what happens.
