How create a button to record a macro in userform

[thanhthanh12]

I had a userform, i created a button in the userform. How can i click the button then a macro will start record? Thank you very much!

 

[dhookom]

Isn’t there already a button on the ribbon for this?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[Andrzejek]

I took it as thanhthanh12 wants to create his own 'record a macro' button on the form and instead of using a button on the ribbon, he wants to click his own button.

If that's the case, I would like to know - why?

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[mintjulep]

Whatever the reason, the answer seems to be call the menu item.

The trick is finding the right ID for it.

https://www.engram9.info/excel-2003-vba/executing-a-menu-item-directly.html

 

[combo]

The problem is that [tt]Application.CommandBars.GetEnabledMso("MacroRecordOrStop")[/tt] returns false, otherwise [tt]Application.CommandBars.ExecuteMso("MacroRecordOrStop")[/tt] would start the recorder.
Anyway, if the userform is shown modeless, there is a full access to ribbon and simple:

Isn’t there already a button on the ribbon for this?

works perfectly.

combo

 

[thanhthanh12]

Thank your help! i will try.