View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do you format data that is part of a drop down menu?

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!!!

"