Macro recording and VB coding differences
- Thread starter mhghg
- Start date
NARAYANK991
Excel Ninja
Hi ,
There are quite a few differences.
1. The macro recorder merely records your actions when you are manipulating the cursor and clicking on the menu options and otherwise interacting with the worksheet.
Since the user may not be the most expert user around , it is possible your actions will not necessarily be the most efficient way to achieve what you want.
Since the macro recorder is faithfully recording your actions , it follows that the code generated using the macro recorder may not be the most efficient code possible to achieve the desired results.
A simple example is that using the macro recorder you will get a lot of worksheet and cell selects , which can be time consuming. Writing the code yourself , you can do away with these time consuming selects.
2. There are several programming constructs such as loops , if statements , functions , which do not have an equivalent in user actions.
The significance of this is that certain outcomes cannot be achieved solely by using cursor manipulation and menu options ; naturally then the macro recorder cannot help in coding such outcomes. VBA will be required in such cases.
There may be other differences , but these two alone are major enough that you should take the time and trouble to learn VBA.
The macro recorder can take you only so far and no further.
Narayan
There are quite a few differences.
1. The macro recorder merely records your actions when you are manipulating the cursor and clicking on the menu options and otherwise interacting with the worksheet.
Since the user may not be the most expert user around , it is possible your actions will not necessarily be the most efficient way to achieve what you want.
Since the macro recorder is faithfully recording your actions , it follows that the code generated using the macro recorder may not be the most efficient code possible to achieve the desired results.
A simple example is that using the macro recorder you will get a lot of worksheet and cell selects , which can be time consuming. Writing the code yourself , you can do away with these time consuming selects.
2. There are several programming constructs such as loops , if statements , functions , which do not have an equivalent in user actions.
The significance of this is that certain outcomes cannot be achieved solely by using cursor manipulation and menu options ; naturally then the macro recorder cannot help in coding such outcomes. VBA will be required in such cases.
There may be other differences , but these two alone are major enough that you should take the time and trouble to learn VBA.
The macro recorder can take you only so far and no further.
Narayan
