Macro to VB Code

Range

Board Regular
Joined
Nov 13, 2010
Messages
140
Is there any benefit/cons in recording a macro and then transfering the code to a command button, etc in terms of speed/memory, etc. Thanks
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Nalani

Well-known Member
Joined
Apr 10, 2009
Messages
1,047
To answer your question - No there is no difference when assigning your Recorded Macro/code to a button.

All you have done there is, instead of Running your macro from the Macros Dialog box is assigned it to a Button. It will still run as you have Recorded it.

Keep in mind that the Recorder, which is a good tool to get started on, does put in unneccessary steps that can be eliminated. This in turn Will make the code run faster.

Example with the Recorder:
Code:
Sub Macro1()
'
' Macro1 Macro
'
'
    Range("A1:A4").Select
    Selection.Copy
    Range("C1").Select
    ActiveSheet.Paste
End Sub

Same code modified:
Code:
Sub Macro2()
    Range("A1:A4").Copy Range("C1")
End Sub

In a nutshell, you normally do not have to Select or Activate when using VBA.
 
Last edited:

Range

Board Regular
Joined
Nov 13, 2010
Messages
140
ahh sweet point mate - thanks.

So in terms of learning to code more efficiently its mainly a case of understanding VB better. **** that means lots of reading and less cheating.
 

Forum statistics

Threads
1,141,734
Messages
5,708,171
Members
421,550
Latest member
Dtcfire

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top