If you use a drop down menu list with data validation, the menu is so small
you can't read it. How do you apply normal formatting to improve the
situation (font size, bold, etc.)

You cannot change the font size in a DV dropdown.

There are workarounds.

See Debra Dalgleish's site for these.

http://www.contextures.on.ca/xlDataVal08.html#Larger


Gord Dibben MS Excel MVP

On Sat, 16 Sep 2006 07:30:02 -0700, Jester
wrote:

If you use a drop down menu list with data validation, the menu is so small
you can't read it. How do you apply normal formatting to improve the
situation (font size, bold, etc.)

I'm using 2007/excel and have a form that was used in excel 2003. I cannot
find where to edit the data in the drop down menu...Please Help!!!

"

What type of dropdown is it?

If DV dropdown list just select the cell then DataValidation

Look in the "Source" dialog for a range or range name.

If a Comboxbox from the Control Toolbox, open Control Toolbox and go into Design
Mode then right-clickPropertiesListFillRange


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 08:57:01 -0700, Sassy <Sassy @discussions.microsoft.com
wrote:

I'm using 2007/excel and have a form that was used in excel 2003. I cannot
find where to edit the data in the drop down menu...Please Help!!!

"

It's a drop down that has several names in it and I still cannot seem to edit
the names to make this doc work. I also, cannot find the combo or control box
within excel 2007...Please help!

"Gord Dibben" wrote:

What type of dropdown is it?

If DV dropdown list just select the cell then DataValidation

Look in the "Source" dialog for a range or range name.

If a Comboxbox from the Control Toolbox, open Control Toolbox and go into Design
Mode then right-clickPropertiesListFillRange


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 08:57:01 -0700, Sassy <Sassy @discussions.microsoft.com
wrote:

I'm using 2007/excel and have a form that was used in excel 2003. I cannot
find where to edit the data in the drop down menu...Please Help!!!

"

I am not familiar with the commands in 2077 so will have to leave this for
someone else.

Or see Ron de Bruin's site for where to find the commands in 2007 menus.

http://www.rondebruin.nl/0307commands.htm


Gord

On Thu, 10 Jul 2008 11:35:18 -0700, Sassy
wrote:

It's a drop down that has several names in it and I still cannot seem to edit
the names to make this doc work. I also, cannot find the combo or control box
within excel 2007...Please help!

"Gord Dibben" wrote:

What type of dropdown is it?

If DV dropdown list just select the cell then DataValidation

Look in the "Source" dialog for a range or range name.

If a Comboxbox from the Control Toolbox, open Control Toolbox and go into Design
Mode then right-clickPropertiesListFillRange


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 08:57:01 -0700, Sassy <Sassy @discussions.microsoft.com
wrote:

I'm using 2007/excel and have a form that was used in excel 2003. I cannot
find where to edit the data in the drop down menu...Please Help!!!

"

Do you know how to format a drop down box where the arrow to the right of the
box does not disappear?

"Gord Dibben" wrote:

What type of dropdown is it?

If DV dropdown list just select the cell then DataValidation

Look in the "Source" dialog for a range or range name.

If a Comboxbox from the Control Toolbox, open Control Toolbox and go into Design
Mode then right-clickPropertiesListFillRange


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 08:57:01 -0700, Sassy <Sassy @discussions.microsoft.com
wrote:

I'm using 2007/excel and have a form that was used in excel 2003. I cannot
find where to edit the data in the drop down menu...Please Help!!!

"

Yes.

Use a CombobBox from the Control ToolBox Toolbar.


Gord

On Fri, 15 Aug 2008 10:09:29 -0700, jr wrote:

Do you know how to format a drop down box where the arrow to the right of the
box does not disappear?

"Gord Dibben" wrote:

What type of dropdown is it?

If DV dropdown list just select the cell then DataValidation

Look in the "Source" dialog for a range or range name.

If a Comboxbox from the Control Toolbox, open Control Toolbox and go into Design
Mode then right-clickPropertiesListFillRange


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 08:57:01 -0700, Sassy <Sassy @discussions.microsoft.com
wrote:

I'm using 2007/excel and have a form that was used in excel 2003. I cannot
find where to edit the data in the drop down menu...Please Help!!!

"

Can you change the text color in a DV Dropdown list? I would like to select
text from the Data Validation dropdown and have the resulting value selected
in the cell colored. Can this be done using Conditional Formatting somehow?
Perhaps a Macro to detect the cell contents change and change the color of
the text depending on the value? Help! :)

"Gord Dibben" wrote:

You cannot change the font size in a DV dropdown.

There are workarounds.

See Debra Dalgleish's site for these.

http://www.contextures.on.ca/xlDataVal08.html#Larger


Gord Dibben MS Excel MVP

On Sat, 16 Sep 2006 07:30:02 -0700, Jester
wrote:

If you use a drop down menu list with data validation, the menu is so small
you can't read it. How do you apply normal formatting to improve the
situation (font size, bold, etc.)

You can change the color after the item has been selected.

Either through CF or event code.

In 2007 you can have 64 CF rules in a cell.

In 2003 only 3 rules for a cell.

Event code could look like this. Assumes A1 is DV dropdown.

Private Sub Worksheet_Change(ByVal Target As Range)
Set r = Range("A1")
If Intersect(Target, r) Is Nothing Then
Exit Sub
End If
vals = Array("C", "D", "G", "H", "K", "L", "O", "S", "C", "X") 'your items
nums = Array(8, 9, 6, 3, 7, 4, 20, 10, 8, 15)
With Target
icolor = 0
For i = LBound(vals) To UBound(vals)
If UCase(r.Value) = vals(i) Then
icolor = nums(i)
End If
Next
If icolor 0 Then
.Font.ColorIndex = icolor
End If
End With
End Sub

If you have many items in your list you may want to employ a lookup table
for vals and nums arrays.


Gord

On Thu, 10 Dec 2009 12:08:01 -0800, Kirk
wrote:

Can you change the text color in a DV Dropdown list? I would like to select
text from the Data Validation dropdown and have the resulting value selected
in the cell colored. Can this be done using Conditional Formatting somehow?
Perhaps a Macro to detect the cell contents change and change the color of
the text depending on the value? Help! :)

"Gord Dibben" wrote:

You cannot change the font size in a DV dropdown.

There are workarounds.

See Debra Dalgleish's site for these.

http://www.contextures.on.ca/xlDataVal08.html#Larger


Gord Dibben MS Excel MVP

On Sat, 16 Sep 2006 07:30:02 -0700, Jester
wrote:

If you use a drop down menu list with data validation, the menu is so small
you can't read it. How do you apply normal formatting to improve the
situation (font size, bold, etc.)