Can you edit a combo box?

M

Mark Hone

Hi,

You can only change the font properties when using a combo box from the
controls toolbar, not one from the forms toolbar.

Assuming you have one set-up from the controls toolbar, do the following:
- Make sure you are in design mode (on the VB toolbar)
- Select your combo box, right-click and select Properties...
- Click into the Font property and it should open a font dialog for you to
change the typeface, size and style.

Click OK, close the property window and the turn off design mode to see the
result.

Hope this helps,

Mark
 
D

Dave Peterson

Is it a combobox from the control toolbox toolbar on a worksheet? Or is it a
combobox in a userform?

If it's on a worksheet, show the control toolbox toolbar.
click on the design mode icon
rightclick on the combobox
select properties and look for font
and double click on it.
(don't forget to leave design mode when you're done.)

Just rightclick on that combobox
choose properties
and double click on Font
(very similar)

=======
If you used data|Validation or the dropdown from the Forms toolbar, then you
can't change the font size.

But Debra Dalgleish has a workaround for Data|Validation at:
http://contextures.com/xlDataVal08.html#Font
 
R

rmellison

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?
 
D

Dave Peterson

Yep. You can use a list for each type (data|validation and a combobox from the
control toolbox toolbar).

For the data|validation, take a look at Debra Dalgleish's site:
http://contextures.com/xlDataVal01.html
(a nice place to start)

For the combobox from the control toolbox.
Show that toolbar
click on the design mode (just like changing the font)

Look for ListFillRange and type your range's address there.
'sheet 2'!a1:A9
for example

Look for linkedcell if you want a, er, linked cell.
 
M

Mark Hone

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 here:
http://www.contextures.com/xlDataVal01.html

Hope this helps,

Mark
 
R

rmellison

Thanks both, will check out the website!


Mark Hone said:
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 here:
http://www.contextures.com/xlDataVal01.html

Hope this helps,

Mark
Click to expand...
 
Top