In this post, I will show you how to add additional controls such as Windows Media Player, Adobe PDF Reader and Microsoft ListView Control in Excel VBA.
So here are the steps you need to follow. First create a blank workbook.
Then click somewhere in the excel sheet and press Alt+F11 to open the VBA editor. Then click on the Insert menu and select Userform.
Once you select the Userform, a new userform will be created like this.
Also the Toolbox will appear to the side of the form as well.
Some of the controls are already in this toolbox such as Textbox, Label and ListBox etc. Now let’s look at how to add additional controls to it. To do that we need to click on the Tools menu and click on Additional Controls...
It will open the Additional Controls Window like this.
Now you can add any additional control you like. For this example let’s add Windows Media Player. Select the checkbox in front of the Windows Media Player and then click OK.
This will add Windows Media Player icon to our Toolbox like this.
Now we can add Windows Media Player to our userform.
