On the Advanced tab developer select button Insert – ActiveX Controls – Other Controls (Developer — Insert — ActiveX — Other controls):
Then in the window that opens, find Windows Media Player, press OK and draw its container on the sheet by holding down the left mouse button:
We remember the name of the inserted component in the upper left corner (usually WindowsMediaPlayer1 or something similar) and press the button Designer mode (Design Mode)to put the player into play mode.
Then right-click on the sheet tab and select the command Source text (Source code). In the macro editor window that opens, enter the following code:
Sub Radio() WindowsMediaPlayer1.Url = ActiveCell WindowsMediaPlayer1.Controls.Play End Sub
We return to Excel, select the cell with the web link to the streaming radio station and run our macro through Developer – Macros (Developer — Macros) or keyboard shortcut Alt+F8. For convenience, you can also make a separate launch button through Developer – Insert – Button (Developer — Insert — Button):
Playing a media stream in no way interferes with working with data on sheets, creating Power Query queries, other macros, etc. happens in a background process.
Simple and tasteful 🙂