Told y'all I'd have this one finished soon!
Mon Jun 01, 2020 10:55 pm
Say Hello to Match Game!!!
It's got User Forms (in fact, ALL my controls but three at the moment are in the user form), Collections, and all VBA... (ignore the twitch window in the background, I was just doing everything on one screen)
I honestly can't wait to come up with some RIDICULOUS Goofy questions for this one...
About the only thing I can't figure out is how to pull data from a google sheet and put it in a PPT textbox...so that'll be the hardest part of the whole thing... Other than that... This one should be fun to participate in!
It's got User Forms (in fact, ALL my controls but three at the moment are in the user form), Collections, and all VBA... (ignore the twitch window in the background, I was just doing everything on one screen)
I honestly can't wait to come up with some RIDICULOUS Goofy questions for this one...
About the only thing I can't figure out is how to pull data from a google sheet and put it in a PPT textbox...so that'll be the hardest part of the whole thing... Other than that... This one should be fun to participate in!
Re: Told y'all I'd have this one finished soon!
Mon Jun 01, 2020 11:22 pm
What if you downloaded the google sheet as an excel spreadsheet? Check out how I did the importing on Jeopardy there.
Re: Told y'all I'd have this one finished soon!
Tue Jun 02, 2020 8:21 am
I'd have to do a download on every question though.. cause the google fors are the guests answers (so nobody sees them)
Re: Told y'all I'd have this one finished soon!
Tue Aug 02, 2022 2:03 pm
I've seen some apps on iOS and the web that say they can send you a notification or an email whenever a webpage that you specify to it changes or is otherwise updated. Maybe you can create similar code for VBA that would connect-to and scan the content of a URL's page, then parce specific lines by number, and copy the text from each of those lines into each of the same number of specified text-boxes on your slide.
Might require an Add-In, though; not sure, I know nothing about proper coding.
Might require an Add-In, though; not sure, I know nothing about proper coding.
Permissions in this forum:
You cannot reply to topics in this forum