Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Peter is talking about his new internet radio in excel.
Sub InternetRadioStart() Dim Path As String Path = Range("F4") If Path = "" Then Exit Sub With Me.InternetRadioInExcel .URL = Path DoEvents .Controls.Play DoEvents End With End Sub
Sub InternetRadioStop() With Me.InternetRadioInExcel .Controls.stop End With End Sub
Now, you have two different macros to control your radio (play & stop).
Get URL for your favorite radio channel from here. And, paste that address into cell F4.
Insert two buttons for play and stop. And, assign macros to those buttons.
Tune In And Enjoy.