|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
Definitely a DV dropdown.
The list for that could be a range of cells on the sheet.
A range of cells on same or another sheet and given a defined name.
The list could be typed into the Source dialog as comma-delimited.
The DV dialog would be under Data>Data Validation>Data>Data Tools or somesuch
command.
You will have to find that dialog for yourself on the worksheet menubar.
Gord
On Thu, 10 Jul 2008 13:35:03 -0700, Sassy <Sassy@discussions.microsoft.com>
wrote:
>Oh...Yes I'm sorry about that yes....The arrow is to the right, you click and
>see the other names that can be clicked and selected...
>
>"Gord Dibben" wrote:
>
>> Probably not that difficult if you know what type of dropdown it is which you
>> have so far neglected to specify.
>>
>> When you select a cell does an Arrow appear at right side of the cell with the
>> list dropdown from there?
>>
>> That would most likely be Data Validation list.
>>
>>
>> Gord
>>
>> On Thu, 10 Jul 2008 12:40:02 -0700, Sassy <Sassy@discussions.microsoft.com>
>> wrote:
>>
>> >I cannot believe it's this difficult to simply remove names from a drop down
>> >list...I'm dying over here...lol
>> >
>> >"Gord Dibben" wrote:
>> >
>> >> 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 <Sassy@discussions.microsoft.com>
>> >> 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 Data>Validation
>> >> >>
>> >> >> 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-click>Properties>ListFillRange
>> >> >>
>> >> >>
>> >> >> 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!!!
>> >> >> >
>> >> >> >"
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
| |
"Gord Dibben" wrote:
> Definitely a DV dropdown.
>
> The list for that could be a range of cells on the sheet.
>
> A range of cells on same or another sheet and given a defined name.
>
> The list could be typed into the Source dialog as comma-delimited.
>
> The DV dialog would be under Data>Data Validation>Data>Data Tools or somesuch
> command.
>
> You will have to find that dialog for yourself on the worksheet menubar.
>
>
> Gord
>
> On Thu, 10 Jul 2008 13:35:03 -0700, Sassy <Sassy@discussions.microsoft.com>
> wrote:
>
> >Oh...Yes I'm sorry about that yes....The arrow is to the right, you click and
> >see the other names that can be clicked and selected...
> >
> >"Gord Dibben" wrote:
> >
> >> Probably not that difficult if you know what type of dropdown it is which you
> >> have so far neglected to specify.
> >>
> >> When you select a cell does an Arrow appear at right side of the cell with the
> >> list dropdown from there?
> >>
> >> That would most likely be Data Validation list.
> >>
> >>
> >> Gord
> >>
> >> On Thu, 10 Jul 2008 12:40:02 -0700, Sassy <Sassy@discussions.microsoft.com>
> >> wrote:
> >>
> >> >I cannot believe it's this difficult to simply remove names from a drop down
> >> >list...I'm dying over here...lol
> >> >
> >> >"Gord Dibben" wrote:
> >> >
> >> >> 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 <Sassy@discussions.microsoft.com>
> >> >> 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 Data>Validation
> >> >> >>
> >> >> >> 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-click>Properties>ListFillRange
> >> >> >>
> >> >> >>
> >> >> >> 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!!!
> >> >> >> >
> >> >> >> >"
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
I simply want to add another name to the DV list that I already have created.
How?
"Gord Dibben" wrote:
> Definitely a DV dropdown.
>
> The list for that could be a range of cells on the sheet.
>
> A range of cells on same or another sheet and given a defined name.
>
> The list could be typed into the Source dialog as comma-delimited.
>
> The DV dialog would be under Data>Data Validation>Data>Data Tools or somesuch
> command.
>
> You will have to find that dialog for yourself on the worksheet menubar.
>
>
> Gord
>
> On Thu, 10 Jul 2008 13:35:03 -0700, Sassy <Sassy@discussions.microsoft.com>
> wrote:
>
> >Oh...Yes I'm sorry about that yes....The arrow is to the right, you click and
> >see the other names that can be clicked and selected...
> >
> >"Gord Dibben" wrote:
> >
> >> Probably not that difficult if you know what type of dropdown it is which you
> >> have so far neglected to specify.
> >>
> >> When you select a cell does an Arrow appear at right side of the cell with the
> >> list dropdown from there?
> >>
> >> That would most likely be Data Validation list.
> >>
> >>
> >> Gord
> >>
> >> On Thu, 10 Jul 2008 12:40:02 -0700, Sassy <Sassy@discussions.microsoft.com>
> >> wrote:
> >>
> >> >I cannot believe it's this difficult to simply remove names from a drop down
> >> >list...I'm dying over here...lol
> >> >
> >> >"Gord Dibben" wrote:
> >> >
> >> >> 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 <Sassy@discussions.microsoft.com>
> >> >> 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 Data>Validation
> >> >> >>
> >> >> >> 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-click>Properties>ListFillRange
> >> >> >>
> >> >> >>
> >> >> >> 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!!!
> >> >> >> >
> >> >> >> >"
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Just below "Definitely a DV dropdown." you will see three sources for DV
lists.
Just add a name to whichever list you're drawing from.
Gord
On Wed, 13 Aug 2008 07:52:19 -0700, Seeker
<Seeker@discussions.microsoft.com> wrote:
>I simply want to add another name to the DV list that I already have created.
> How?
>
>"Gord Dibben" wrote:
>
>> Definitely a DV dropdown.
>>
>> The list for that could be a range of cells on the sheet.
>>
>> A range of cells on same or another sheet and given a defined name.
>>
>> The list could be typed into the Source dialog as comma-delimited.
>>
>> The DV dialog would be under Data>Data Validation>Data>Data Tools or somesuch
>> command.
>>
>> You will have to find that dialog for yourself on the worksheet menubar.
>>
>>
>> Gord
>>
>> On Thu, 10 Jul 2008 13:35:03 -0700, Sassy <Sassy@discussions.microsoft.com>
>> wrote:
>>
>> >Oh...Yes I'm sorry about that yes....The arrow is to the right, you click and
>> >see the other names that can be clicked and selected...
>> >
>> >"Gord Dibben" wrote:
>> >
>> >> Probably not that difficult if you know what type of dropdown it is which you
>> >> have so far neglected to specify.
>> >>
>> >> When you select a cell does an Arrow appear at right side of the cell with the
>> >> list dropdown from there?
>> >>
>> >> That would most likely be Data Validation list.
>> >>
>> >>
>> >> Gord
>> >>
>> >> On Thu, 10 Jul 2008 12:40:02 -0700, Sassy <Sassy@discussions.microsoft.com>
>> >> wrote:
>> >>
>> >> >I cannot believe it's this difficult to simply remove names from a drop down
>> >> >list...I'm dying over here...lol
>> >> >
>> >> >"Gord Dibben" wrote:
>> >> >
>> >> >> 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 <Sassy@discussions.microsoft.com>
>> >> >> 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 Data>Validation
>> >> >> >>
>> >> >> >> 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-click>Properties>ListFillRange
>> >> >> >>
>> >> >> >>
>> >> >> >> 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!!!
>> >> >> >> >
>> >> >> >> >"
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Hi,
I know how to create a drop down list, but how do I add a "blank" so
whoever is is filling it out can write it in (i.e. your list contains "apple"
& "banana" only and then you someone wants to enter in orange, but it's not
available on the drop down list, is there an option where they can just write
it in rather then having to chose from apple and banana?)?
"Gord Dibben" wrote:
> Just below "Definitely a DV dropdown." you will see three sources for DV
> lists.
>
> Just add a name to whichever list you're drawing from.
>
>
> Gord
>
>
> On Wed, 13 Aug 2008 07:52:19 -0700, Seeker
> <Seeker@discussions.microsoft.com> wrote:
>
> >I simply want to add another name to the DV list that I already have created.
> > How?
> >
> >"Gord Dibben" wrote:
> >
> >> Definitely a DV dropdown.
> >>
> >> The list for that could be a range of cells on the sheet.
> >>
> >> A range of cells on same or another sheet and given a defined name.
> >>
> >> The list could be typed into the Source dialog as comma-delimited.
> >>
> >> The DV dialog would be under Data>Data Validation>Data>Data Tools or somesuch
> >> command.
> >>
> >> You will have to find that dialog for yourself on the worksheet menubar.
> >>
> >>
> >> Gord
> >>
> >> On Thu, 10 Jul 2008 13:35:03 -0700, Sassy <Sassy@discussions.microsoft.com>
> >> wrote:
> >>
> >> >Oh...Yes I'm sorry about that yes....The arrow is to the right, you click and
> >> >see the other names that can be clicked and selected...
> >> >
> >> >"Gord Dibben" wrote:
> >> >
> >> >> Probably not that difficult if you know what type of dropdown it is which you
> >> >> have so far neglected to specify.
> >> >>
> >> >> When you select a cell does an Arrow appear at right side of the cell with the
> >> >> list dropdown from there?
> >> >>
> >> >> That would most likely be Data Validation list.
> >> >>
> >> >>
> >> >> Gord
> >> >>
> >> >> On Thu, 10 Jul 2008 12:40:02 -0700, Sassy <Sassy@discussions.microsoft.com>
> >> >> wrote:
> >> >>
> >> >> >I cannot believe it's this difficult to simply remove names from a drop down
> >> >> >list...I'm dying over here...lol
> >> >> >
> >> >> >"Gord Dibben" wrote:
> >> >> >
> >> >> >> 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 <Sassy@discussions.microsoft.com>
> >> >> >> 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 Data>Validation
> >> >> >> >>
> >> >> >> >> 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-click>Properties>ListFillRange
> >> >> >> >>
> >> >> >> >>
> >> >> >> >> 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!!!
> >> >> >> >> >
> >> >> >> >> >"
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
Turn off the Error Alert option.
This will allow entering something other than what's on the list but it
won't "add" it to the list for future use.
To do that requires code.
See Debra Dalgleish's site for a sample workbook.
http://www.contextures.on.ca/excelfiles.html#DataVal
Gord
DV0012 - Update Validation List -- type a new value in a cell that contains
data validation, and it's automatically added to the source list, and the
list is sorted; a macro automates the list updates. DataValListAddSort.zip
11 kb
On Thu, 14 Aug 2008 12:58:00 -0700, Nur <Nur@discussions.microsoft.com>
wrote:
>Hi,
>
> I know how to create a drop down list, but how do I add a "blank" so
>whoever is is filling it out can write it in (i.e. your list contains "apple"
>& "banana" only and then you someone wants to enter in orange, but it's not
>available on the drop down list, is there an option where they can just write
>it in rather then having to chose from apple and banana?)?
>
>"Gord Dibben" wrote:
>
>> Just below "Definitely a DV dropdown." you will see three sources for DV
>> lists.
>>
>> Just add a name to whichever list you're drawing from.
>>
>>
>> Gord
>>
>>
>> On Wed, 13 Aug 2008 07:52:19 -0700, Seeker
>> <Seeker@discussions.microsoft.com> wrote:
>>
>> >I simply want to add another name to the DV list that I already have created.
>> > How?
>> >
>> >"Gord Dibben" wrote:
>> >
>> >> Definitely a DV dropdown.
>> >>
>> >> The list for that could be a range of cells on the sheet.
>> >>
>> >> A range of cells on same or another sheet and given a defined name.
>> >>
>> >> The list could be typed into the Source dialog as comma-delimited.
>> >>
>> >> The DV dialog would be under Data>Data Validation>Data>Data Tools or somesuch
>> >> command.
>> >>
>> >> You will have to find that dialog for yourself on the worksheet menubar.
>> >>
>> >>
>> >> Gord
>> >>
>> >> On Thu, 10 Jul 2008 13:35:03 -0700, Sassy <Sassy@discussions.microsoft.com>
>> >> wrote:
>> >>
>> >> >Oh...Yes I'm sorry about that yes....The arrow is to the right, you click and
>> >> >see the other names that can be clicked and selected...
>> >> >
>> >> >"Gord Dibben" wrote:
>> >> >
>> >> >> Probably not that difficult if you know what type of dropdown it is which you
>> >> >> have so far neglected to specify.
>> >> >>
>> >> >> When you select a cell does an Arrow appear at right side of the cell with the
>> >> >> list dropdown from there?
>> >> >>
>> >> >> That would most likely be Data Validation list.
>> >> >>
>> >> >>
>> >> >> Gord
>> >> >>
>> >> >> On Thu, 10 Jul 2008 12:40:02 -0700, Sassy <Sassy@discussions.microsoft.com>
>> >> >> wrote:
>> >> >>
>> >> >> >I cannot believe it's this difficult to simply remove names from a drop down
>> >> >> >list...I'm dying over here...lol
>> >> >> >
>> >> >> >"Gord Dibben" wrote:
>> >> >> >
>> >> >> >> 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 <Sassy@discussions.microsoft.com>
>> >> >> >> 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 Data>Validation
>> >> >> >> >>
>> >> >> >> >> 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-click>Properties>ListFillRange
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >> 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!!!
>> >> >> >> >> >
>> >> >> >> >> >"
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
Question
Answer
Notify me of replies