Part 1: Prepare The Elements (Video)
Part 1: Prepare The Elements (Written Steps)
Make sure the Blank Start file is open before moving on to step 1.
1. You need to add two text boxes
Go to the “Developer” tab and select the “Insert” drop-down.
On the drop-down, under ActiveX Controls, select the “Text Box.” Then move your mouse to cell “A7” and click.
Do this a second time, In the “Insert” drop-down select “Text Box” again, then move your mouse to cell “B7”
You may have to adjust the widths and location of the text boxes some. When you are finished, it should look pretty close to this:
2. Now you need to add a button
Go to the “Developer” tab and select the “Insert” drop-down.
On the drop-down, under ActiveX Controls, select the “Command Button.” Then move your mouse to cell “B8” and click.
3. Adjust your properties
It may be difficult, not impossible, to follow along with the additional parts if you do not choose the names I have chosen for the text boxes and the command button.
Under the “Developer” tab, select “Properties” and change the properties for each element you added in the first two steps. With “Properties” selected, you should only have to click on each element and make the changes.
The properties for the three elements are shown below, with the red boxed areas showing what I changed from default:
When you are finished, your Excel document should look pretty close to this:
4. Prepare the coding for the button for Part 2
Just double-click the “Add To Favorites” button you created, this should auto create a code block for you that should look like this:
Next Page: Part 2
Categories: Excel, Technology, Tutorials, VBA