Kaiser
出典: くみこみックス
Also, you will want the Macro recorder even immediately after you discover tips on how to produce macros from scratch; I nonetheless use it to record very simple macros and as an Excel VBA material supplier.
So let us get started...
1) The Excel recorder registers each individual motion you execute on Excel
On your own audio recording device; though the History button is pressed, all the things is recorded: your voice and also the track record sounds. On Excel; a similar point comes about; though it truly is in recording style each motion is recorded.
These steps may very well be: picking a mobile, crafting a formula, scrolling, formatting a cell, zooming, etc.
And each action is published on a line per line basis.
Take note of which the exact way a voice recording captures your hesitations and qualifications sounds, the Macro recorder captures every little thing you do, together with your errors and incidental steps.
two) The Excel recorder generates a VBA instruction after the supplied action may be executed on Excel
Any time you document your voice, you have to talk to begin with therefore the recording gadget captures your speech; the exact same thing happens with Excel Macros.
You might want to complete an motion on Excel (see left window below) so the Excel recorder registers it.
This can be one of several primary shortcomings to create good applications. A Macro doesn't have circulation manage, it starts off and stops. It's no anticipation, no decision.
The distinctive solution to create good programs is by strengthening a Macro or by creating it from scratch.
3) The Excel recorder improvements the "properties" of Excel objects programmatically
At first sight the generated VBA language is Greek; very little far more far from truth.
Decode the VBA language grammar swiftly by reading a short introduction to objects...
On the authentic planet, your hair has properties: length, color, sort; you could minimize it, adjust its condition, etc. Your hair behaves in precise ways: it grows, it falls, and many others.
Some qualities is usually modified, much like the shade. Of course you'll be able to utilize a beauty treatment method and turn your black hair into crimson, blond, and many others.
Some attributes are read-only, you are able to know them however , you can not adjust them. For instance: your hair form: curly, straight.
Let us summarize the features of one's hair...
A hair Residence is exactly what you hair is: size, color, etc. A hair Method is exactly what you are able to do together with your hair: slash it, change its shape A hair Celebration is the way it behaves: it grows, it falls, etc. Now back to Excel...
Excel has homes and strategies as well, so you can manipulate them by utilizing VBA language.
That you are fully conscious in the way you alter houses of Excel objects, you are aware of how to modify the colour of the cell, the font, the name of the sheet, etc. However, you are not really informed of how you can improve them programmatically; a Macro preforms that extremely easily.
