Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can you edit a combo box?
How do you edit the font size etc in a combo box form?
|
#2
|
|||
|
|||
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 "rmellison" wrote: How do you edit the font size etc in a combo box form? |
#3
|
|||
|
|||
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 rmellison wrote: How do you edit the font size etc in a combo box form? -- Dave Peterson |
#4
|
|||
|
|||
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? "Dave Peterson" wrote: 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 rmellison wrote: How do you edit the font size etc in a combo box form? -- Dave Peterson |
#5
|
|||
|
|||
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. 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? "Dave Peterson" wrote: 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 rmellison wrote: How do you edit the font size etc in a combo box form? -- Dave Peterson -- Dave Peterson |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
Thanks both, will check out the website!
"Mark Hone" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit Links - Combo Box Problem | Excel Worksheet Functions | |||
Nesting Combo Boxes /Returning an Array | Excel Discussion (Misc queries) | |||
connecting combo boxes to yield data in another cell. | Excel Discussion (Misc queries) | |||
dynamic combo boxes | Excel Worksheet Functions | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) |