edit font in drop down list

ropark1 · May 22nd, 2002, 09:59 AM

Can you edit the text in a drop down list box?

Juan Pablo González · May 22nd, 2002, 10:13 AM

Edit the text ? or edit the font ?

With FORMS controls, you CAN'T either one.

With Data Validation, you can have both (Uncheck the Error Message to be able to enter stuff that doesn't appear in the list)

With ACTIVEX controls, you can have both.

Iain Lewis · May 22nd, 2002, 10:14 AM

Have a look at the properties of the control yuo want to change.

If it's on a userform then with the VBE ( Visual Basic Editor ) open hit F4 - this will display the properties window.

If it's a control on a worksheet then switch to Design Mode ( a button that looks like a set square & pencil ), right click on the control & select properties.

If it's neither of these, & I've completely missed the point, please post back with more details.

HTH

Iain

ropark1 · May 22nd, 2002, 11:43 AM

This is a drop down box with 5 options for selection, it appears that the default font is 8 or 9 pt font, I would like to change that font size to match the fonts on the spreadsheet.

besquerra · Oct 30th, 2003, 03:16 AM

Hi everyone,

is there a way to change the font related to a drop down box when in the filter options? So what I'm asking is that when you filter a column and click the down arrow - a box appears - can you make that bigger?

Thanks for you help,

Brian from Maui · Oct 30th, 2003, 03:29 AM

If you're using a drop down menu using Data Validation, you can't change the font size. You may be able to use this mehod,

http://www.mrexcel.com/board2/viewto...ight=font+size

May 22nd, 2002, 10:13 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Edit the text ? or edit the font ? With FORMS controls, you CAN'T either one. With Data Validation, you can have both (Uncheck the Error Message to be able to enter stuff that doesn't appear in the list) With ACTIVEX controls, you can have both. __________________ Regards, Juan Pablo González http://www.juanpg.com

Oct 30th, 2003, 03:16 AM	#5
besquerra New Member Join Date: Oct 2003 Posts: 1	Re: edit font in drop down list Hi everyone, is there a way to change the font related to a drop down box when in the filter options? So what I'm asking is that when you filter a column and click the down arrow - a box appears - can you make that bigger? Thanks for you help,

Oct 30th, 2003, 03:29 AM	#6
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Re: edit font in drop down list If you're using a drop down menu using Data Validation, you can't change the font size. You may be able to use this mehod, http://www.mrexcel.com/board2/viewto...ight=font+size

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 09:59 AM	#1
ropark1 New Member Join Date: May 2002 Posts: 4	Can you edit the text in a drop down list box?

May 22nd, 2002, 10:14 AM	#3
Iain Lewis Board Regular Join Date: Apr 2002 Location: Midlands, UK Posts: 217	Have a look at the properties of the control yuo want to change. If it's on a userform then with the VBE ( Visual Basic Editor ) open hit F4 - this will display the properties window. If it's a control on a worksheet then switch to Design Mode ( a button that looks like a set square & pencil ), right click on the control & select properties. If it's neither of these, & I've completely missed the point, please post back with more details. HTH Iain

May 22nd, 2002, 11:43 AM	#4
ropark1 New Member Join Date: May 2002 Posts: 4	This is a drop down box with 5 options for selection, it appears that the default font is 8 or 9 pt font, I would like to change that font size to match the fonts on the spreadsheet.