A couple quick snippets of VBA code that can help you impress your friends although might not have much real utility.
First up: have Excel speak to you
Application.speech.speak “text”
Where text is what you want Excel to say. Just like with any other code you can of course use variables for this to alternate. You could create a list to cycle through various messages as well.
Another one: opening a URL
ThisWorkbook.FollowHyperlink “http://www.google.com”
The above code will open Google when triggered in the default browser.
Add a Comment
You must be logged in to post a comment