Microsoft Office Tutorials and References
In Depth Information
boxes or buttons that you copied on to your image library worksheet, these buttons
are made from Excel table cells, borders, and text. You can change their size as well
as the text so that they are much more flexible than static graphics.
The boxes (text entry fields, combo boxes, and so on) that are represented in
Figure 4.1 were used in a Web application interface. By including this worksheet
as part of your template, you will save yourself hours of work in the future.
Creating the Boxes & Buttons Worksheet
Start by opening your Excel template and right-clicking the Canvas tab to create a
new worksheet the same way you created the Image Library. Name this worksheet
boxes and buttons .
Your first box is a combo box control that uses bordered table cells and a graphic
from the Graphics Library (Figure 4.7, page 58).
To Create the Combo Box:
1. Using your cursor, select a horizontal area of cells.
2. With the cells highlighted, right-click and choose Format Cells (Figure 4.8,
3. Click the Border tab.
4. For this exercise you will change the default border color to a dark gray.
5. In the lower-right corner, click the down arrow next to Automatic under
Color. A color palette will appear.
6. Select the middle gray by clicking it (Figure 4.9, page 60). All the line styles
will now be this gray color.
7. Select the two-pixel line (Figure 4.10, page 61). In the center of the dialog box
is a white box labeled Border with small tick marks. The tick marks represent
the table cells that were highlighted on the worksheet.
8. Click in the upper-left part of the box with the arrow (Figure 4.11, page 62).
9. Then click the one-pixel line in the Style box.
10. Returning to the Border box, click the left and bottom sides of the box
(Figure 4.12, page 63).
13. Click OK. After you deselect the table cells, you see a box that appears to be
recessed, just like a normal input field (Figure 4.13, page 64).