Call a macro within VBA

D

DaveNUFC

Joined
Feb 20, 2010
Messages
3
Reaction score
0
Hi all,

I am trying to execute a macro within a VBA code for a enter button on a user form.

I have tried both the application.run and runCMD coding but nothing seems to work,
 
Does DoCmd.RunMacro "" work?

If not, Application.Run "PERSONAL.XLS!Name of your Macro here"?

I'm not an expert at Excel, but thought it may be worth a shot. :)
 
Hi Ian, I should have been more specific in my initial post...

Basically what I am trying to do is execute a macro from a different module within a userform when the enter button is clicked, if that is possible

I have even tried pasting the macro in its entirety within the enter button code but that doesn't work either

The macro works fine on its own, I just can't seem to combine it with the userform

many thanks

David
 
Back
Top