Hi,

To populate a controls combo box from a range of cells, do the following:
- Make sure you are in design mode (on the VB toolbar)
- Select your combo box, right-click and select Properties...
- Under the ListFillRange proprty, type in the cell range (unfortunately you
can't just point and click as you can with the forms combo box).

There is also a LinkedCell property, which works in the same way if you want
to retrieve the selected value into a cell somewhere.

Data Validation can be used to present a drop-down list to the user in much
the same way as a combo box control.

To get up to speed on data validation, I (like Dave) would also recommend
Debra Dalgleish's web-site. Try starting he
http://www.contextures.com/xlDataVal01.html

Hope this helps,

Mark


"rmellison" wrote:

I'm using a dropdown list from the forms toolbar. That'll be why I can't
change the font!

The reason I'm using the combobox from the forms toolbar is that I'm not
sure how to set-up a control combo box to show a list from a cell range. In
the Format Control option it doesn't have the 'control' tab, unlike for a
forms tool. I should imagine there's a way to do it, but haven't figured that
out yet. Does involve some VBA magic?

Similarly, I just tried messing around with Data | Validation and didn't get
very far. Can this be used to represent a dropdown list for a given cell
range as well?