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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

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,175,996
Messages
5,900,767
Members
434,851
Latest member
TorFey

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