User form in PowerPoint to feed Excel database

[pcowner]

I'd created a presentation/tutorial in MS PowerPoint, run it in a terminal mode, where users navigate through vba coded buttons. Now, I'm figuring a way to capture who views the PowerPoint (also, trying to capture their feedback). Could anyone please help with a vba code that could be tied to a userform in the beginning or the end of the presentation that would allow users to fill and submit the feedback/registrations? Could an embedded Excel w/VBA help with this?

Additional background info... as an admin, I upload 1 PP slide and it propagates to our public desktops in our classroom. Desktops are locked by the IT and there is no email client installed.

 

[pcowner]

Thank you. I looked at it, very impressive. I see some code is marked with ' as a text to not execute. Let say an excel sign-in template is named as: "Template," located on the desktop, how do I invoke the form?

Also, would it be possible to integrate the form to a google form, so the data collection is centralized?

 

[Worf]

The example below loads a Google form, is this what you want?

' slide module
Private Sub CommandButton1_Click()
ActivePresentation.FollowHyperlink _
Address:="https://docs.google.com/forms/d/e/1FAIpQLSfzwTPVnBjXjnuPmRSRdlZbwO4afQaJEveg2TYEra3S_cv1JA/viewform", _
    NewWindow:=True, AddHistory:=True
End Sub