Excel

Excel Visual Basic #4: Create A Web Favorites List

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”

img1

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:

img2

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.

img3

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.

img4

The properties for the three elements are shown below, with the red boxed areas showing what I changed from default:

img5

 

When you are finished, your Excel document should look pretty close to this:

img6

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:

Img7

 


Next Page: Part 2

Pages: 1 2 3 4 5

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.