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