Modules in custom ribbon

[Derrick T. Davidson]

I have figured out how to include a macro in my custom ribbon "<button id="RunMyMacro2" label="Save and Close" onAction="Quit"/>" , however I am unsure if I can include a module I have the attached coded module in my database " Private Sub ExtBtn_Click()
Dim Msg, Style, Title, Response, MyString
Msg = "Are you sure you want to close the database?"
Style = vbYesNo + vbCritical + vbDefaultButton2


Title = "You Are Closing The Database"
Response = MsgBox(Msg, Style, Title)
If Response = vbYes Then
MyString = "Yes"
DoCmd.Quit acQuitSaveAll
Else
MyString = "No"
DoCmd.CancelEvent
End If
End Sub" Can I include it in my code somehow, alternatively can I translate the module into a macro as the yes no cancel option is not included in the standard macro builder?

[June7]

Site for custom ribbons http://www.accessribbon.de/en/?Welcome, provides sample databases. It helped me get my simple custom ribbon setup but I confess there is a lot in those examples that baffle me.

This also helped http://office.microsoft.com/en-us/ac...010211415.aspx

The best I could accomplish was to have a custom ribbon button call a macro and the macro runs VBA function. I think the VBA code must be Public function in a general module.

Don't really understand your last question.