Add record macro in existing code

[K Jenkins]

Hi,

Is there a way to add in an existing VBA code a new macro but from record macro function?+

And if so, how?

Thanks in advance

 

[Joe4]

Are you asking whether or not you can designate a macro you are recording to be placed in a specific module instead of a new one?
If so, why is that necessary?
If that is not what you are after, please explain in more detail, as your question is not clear.

 

[K Jenkins]

Hi,

Yes, that is what I am asking

The reason being that there is already a good code written and I just want to add one small procedure to make more automated.

Yes, I understand that it may sound as an exaggeration that I want to press one button instead of two to run the macros

Thanks again.

 

[Joe4]

Yes, I understand that it may sound as an exaggeration that I want to press one button instead of two to run the macros

It sounds like you want to go further than putting it in the same module; it sounds like you want it in the same sub procedure.

The answer is no, you cannot record a macro and have it automatically go into an already existing procedure ("macro"). But it is really easy to combine them into one in the VB Editor.

Let's say that you record two macros, so they look like this in the VB Editor:

Sub Macro1()

'   Your recorded code here for macro1

End Sub


Sub Macro2()

'   Your recorded code here for macro2

End Sub

Just copy and paste the body of the second macro into the bottom of the first (then delete the second), so it looks like this:

Sub Macro1()

'   Your recorded code here for macro1

'   Your recorded code here for macro2

End Sub

That's all you have to do.