Quote Originally Posted by Getalinks View Post
1) Can you change the font size in the box?
Yes. I assume you are not familiar with these controls so I'll give you a little more detail than I did before.
  1. In Excel 2003, right click on an empty spot on your menu/toolbar space to get a list of toolbars, then check "Control Toolbox."
  2. From that toolbar, click on the leftmost icon that looks like a pencil, ruler, and triangle. That is the "Design Mode" button.
  3. Then right-click on the dropdown box (actually called a combobox). From that menu, select Properties. The properties will be listed in alphabetical order.
  4. Note the Font property. Click on the button to the right of the font name (has three dots in it), and you will get a box to format the font however you want--size, face, bold, etc. If you make the font larger, you will need to adjust the size of the combobox by dragging sides or corners, just like any other graphical object.
  5. The close the Properties box, and click on the Design Mode button again to exit design mode.
2) Is there a way to make it so only the list choices are able to be entered in the box? (i.e. If someone enters "test" and there is no "test" choice in the choices it won't let them enter it.)
There is a way documented but it does not seem to work for me. Following instructions as above, find the "Match Required" property and set it to TRUE. However, I find this has no effect in the sample workbook I posted.

Quote Originally Posted by Excel Help
If the MatchRequired property is True, the user cannot exit the ComboBox until the text entered matches an entry in the existing list. MatchRequired maintains the integrity of the list by requiring the user to select an existing entry.
I am going to post a new thread specific to that issue.