在Word和Excel的下拉選擇表

For Excel:

1. First of all create a list of items for selection, for example, the allowed items are put in A1:A4.
2. Place the cursor on the cell where you want the pull down to appear.
3. From the menu select Data-->Validation
4. In the Drop Down Box "Allow", select List
5. A box "Source" appears. Enter the list of items here. (That is $A$1:$A$4)
6. Press OK
7. You will see the Drop Down Button. This is done.
8. You may copy the cell to other cells, and the newly copies cells will have the same drop down.
9. The usual Excel calculation / manipulation still applies for these cells.

For Word:
1. First of all, you need to enable the "Forms" toolbar, by
Tools --> Customize
Under the tab "Toolbars" put a tick against "Forms"
2. You can insert a drop down form by pressing the "Drop Down Form Field" button on the Forms Toolbar.
3. Double click on the newly created drop down form. Enter the desired text in the dialogue box "Drop down item". Press the Add button to move the desired text to the box on the right. Continue until all probable texts are entered. The press OK.
4. Click the Protect Form button on the Form Toolbar to complete the process.

Examples and the instructions are prepared in the files you can download from the below link.

http://www.funp.net/487854

下面是節錄自 www.exceltips.com 的 tips:





Working with the Combo Box
A list of the cell ranges in the sheet is attached to the Combo Box. After an item is selected from the list, the Combo Box enters into the linked cell the ordinal number of the item that is selected on the list.

Step 1: Define names
1.Enter the months list - January-December into the cells A1 to A12 in the new worksheet.
2.Select cells A!:A12, press Ctrl+F3, enter the text MonthsList into the Names In workbook box, and click OK.
3.Select Cell B1, press Ctrl+F3, enter the text MonthNumber into the Names in Workbook box, and click OK.


Step 2: Add a Combo Box to a worksheet
1. Select one of the toolbars, right-click, and select the Forms toolbar.
2. Copy the Combo Box by clicking the Combo Box icon, and then release the mouse. Create a rectangle with the mouse in the worksheet, and then release the mouse.

Step 3: Format the Combo Box

1.Select the Combo Box; right-click; and from the shortcut menu that appears, select Format Control. Then select the Control tab

2.In the Input range box, type the name MonthsList (You cannot press F3 to paste a name with an object).
3.In the Cell link box, type the name MonthNumber.
4.Click to select the 3-D shading box (more aesthetic).
5.Click OK.
Exit the formatting mode of Combo Box, and select a cell in the sheet. Open the list of items in the Combo Box, and select a month. Note that the new month number is shown in cell B1.






圖片參考：http://www.exceltip.com/images/spacer.gif


2009-06-17 11:30:48 補充：
可參考已為你製作好的 sample file:
http://www.geocities.com/shin_bingo_dog/Combobox.xls