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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0
vba macro that allows insertion of symbols at cursor 0
vba powerpoint pasting named shape in selected named slides 0
Excel VBA - Problem with Closing Print Preview 0
Need help on VBA excel macro and API to close an external application 0
Run code from another workbook 7
VBA script for mathtype equations 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1

Back
Top