User form in PowerPoint to feed Excel database

pcowner

New Member
Joined
Aug 1, 2019
Messages
6
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?
 
Last edited:

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Worf

Well-known Member
Joined
Oct 30, 2011
Messages
4,004
The example below loads a Google form, is this what you want?

Code:
' 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
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,102,447
Messages
5,486,950
Members
407,574
Latest member
Greso

This Week's Hot Topics

Top