Hello everybody. In this video, I'm going to be using Microsoft Excel 2010. I was asked a question by one of my viewers, and that question is: when using a VBA user form that has a command button, how can you use that button to open up a new user form with a web browser? Now, we're not going to be using the create object Internet Explorer that application method. Instead, we're going to be using the web browser control that is built into Microsoft Excel. So, to get started, we're going to go to our developer tab. And of course, you know, be in a new workbook. But since we haven't already set, we're going to go to our Visual Basic environment. I'm going to go to use this drop down to insert a user form. So, we have our blank user form. Just I'm just going to click the user form. And to our left, we have our properties. This is the default location. If you don't see it, go to view and select properties window. I'm going to go to my caption, and we're going to change this to just main. You can name it whatever you'd like. In this case, I'm going to name mine main. And for our tool, I'm going to go to tools. I'm going to hit additional controls. I'm going to scroll down until I have Microsoft web browser checkmark. In this case, mine's already checkmarked. But more than likely, on your application, if you have it's at the sub already, and that icon's not going to be there. By going into tech, mark Microsoft web browser, or, in this case, so select it, go ahead and hit OK. This icon with the earth should show up. In this case, that's our...
Award-winning PDF software
Video instructions and help with filling out and completing Form 2220 Browse
