thanhthanh12
Technical User
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!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How create a button to record a macro in userform
- Thread starter thanhthanh12
- Start date
- Status
Isn’t there already a button on the ribbon for this?
Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016
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
If that's the case, I would like to know - why?
---- Andy
"Hmm...they have the internet on computers now"--Homer Simpson
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:
combo
Anyway, if the userform is shown modeless, there is a full access to ribbon and simple:
works perfectly.dhookom said:
combo
- Thread starter
- #6
- Status
Similar threads
- Locked
- Question
- Locked
- Helpful tip
- Locked
- Question
- Locked
- Question