Data Validation list boxes

Hi--
I have three columns which have data validation list boxes attached, so =
that=20
when you click on a cell a little handle appears and you select a name =
from=20
the list box that appears. In one of the columns, however (and always =
the=20
same one), the handle doesn't show up. When you to type in a cell, the=20
warning box still appears saying that you have to select data from the =
list,=20
but the handle never appears, making selection impossible.=20

Thinking the workbook was corrupt, I tried copying the whole sheet into =
a=20
new workbook, and the validation in the problem column did work for a=20
while, but now it's gone again. The other two validated columns continue =
to=20
work fine.

Help! Is my file just hopelessly corrupt? I'm running this on Mac OSX--
might that be connected to the instability? Any ideas would be much=20
appreciated.

My dear Watson,

Tell us exactly what the Data - Validations settings are in one of the
errant cells are. Look in all three Data Validation tabs.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Watson" <anonymous@discussions.microsoft.com> wrote in message
news:009501c52e51$a16bc370$a601280a@phx.gbl...
Hi--
I have three columns which have data validation list boxes attached, so that
when you click on a cell a little handle appears and you select a name from
the list box that appears. In one of the columns, however (and always the
same one), the handle doesn't show up. When you to type in a cell, the
warning box still appears saying that you have to select data from the list,
but the handle never appears, making selection impossible.

Thinking the workbook was corrupt, I tried copying the whole sheet into a
new workbook, and the validation in the problem column did work for a
while, but now it's gone again. The other two validated columns continue to
work fine.

Help! Is my file just hopelessly corrupt? I'm running this on Mac OSX--
might that be connected to the instability? Any ideas would be much
appreciated.

I see you got the Holmes reference. Sorry about the delay--I had to =
leave=20
the office for the day. The settings are=20
as follows:
ALLOW: List
DATA: between
SOURCE: =3D$AT$13:$AT$17 (These cells contain the items that should=20
appear on the list.)
IGNORE BLANK is checked
IN-CELL DROPDOWN is checked
SHOW INPUT MESSAGE is checked (but there is no message)
SHOW ERROR ALERT is checked
TITLE is Error Alert
STYLE is stop
ERROR MESSAGE (I won't bore you with the text--it's about 110 =
characters)

That's it--except for the source cells and error text, the settiings are =
the=20
same as for the others validations that work. Sigh. Any ideas?

>-----Original Message-----
>My dear Watson,
>
>Tell us exactly what the Data - Validations settings are in one of the=20
>errant cells are. Look in all three Data Validation tabs.
>
>--=20
>Earl Kiosterud
>mvpearl omitthisword at verizon period net
>-------------------------------------------
>
>"Watson" <anonymous@discussions.microsoft.com> wrote in message=20
>news:009501c52e51$a16bc370$a601280a@phx.gbl...
>Hi--
>I have three columns which have data validation list boxes attached, so =

that
>when you click on a cell a little handle appears and you select a name =
from
>the list box that appears. In one of the columns, however (and always =
the
>same one), the handle doesn't show up. When you to type in a cell, the
>warning box still appears saying that you have to select data from the =
list,
>but the handle never appears, making selection impossible.
>
>Thinking the workbook was corrupt, I tried copying the whole sheet into =
a
>new workbook, and the validation in the problem column did work for a
>while, but now it's gone again. The other two validated columns =
continue=20
to
>work fine.
>
>Help! Is my file just hopelessly corrupt? I'm running this on Mac =
OSX--
>might that be connected to the instability? Any ideas would be much
>appreciated.=20
>
>
>.
>

Watson,

If Allow is set to List, then Between should be grayed out. You said it's
set to "between." If it's not grayed out, something is broken. "I'll take
'Things that don't work for $100, Alex.'" I suppose you could deselect Show
Input Message, since there is none. That might work as well as standing up
and turning around three times. Does this workbook use User-defined
Functions (UDF's), by any chance (macros that return a value in a cell)?

Pressing Alt-DownArrow brings up the dropdown, same as clicking the
(missing) button. Try that on an errant cell.

Other than that, I don't have any suggestions.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Watson" <anonymous@discussions.microsoft.com> wrote in message
news:050101c52ee9$8723dfa0$a601280a@phx.gbl...
I see you got the Holmes reference. Sorry about the delay--I had to leave
the office for the day. The settings are
as follows:
ALLOW: List
DATA: between
SOURCE: =$AT$13:$AT$17 (These cells contain the items that should
appear on the list.)
IGNORE BLANK is checked
IN-CELL DROPDOWN is checked
SHOW INPUT MESSAGE is checked (but there is no message)
SHOW ERROR ALERT is checked
TITLE is Error Alert
STYLE is stop
ERROR MESSAGE (I won't bore you with the text--it's about 110 characters)

That's it--except for the source cells and error text, the settiings are the
same as for the others validations that work. Sigh. Any ideas?

>-----Original Message-----
>My dear Watson,
>
>Tell us exactly what the Data - Validations settings are in one of the
>errant cells are. Look in all three Data Validation tabs.
>
>--
>Earl Kiosterud
>mvpearl omitthisword at verizon period net
>-------------------------------------------
>
>"Watson" <anonymous@discussions.microsoft.com> wrote in message
>news:009501c52e51$a16bc370$a601280a@phx.gbl...
>Hi--
>I have three columns which have data validation list boxes attached, so
that
>when you click on a cell a little handle appears and you select a name from
>the list box that appears. In one of the columns, however (and always the
>same one), the handle doesn't show up. When you to type in a cell, the
>warning box still appears saying that you have to select data from the
>list,
>but the handle never appears, making selection impossible.
>
>Thinking the workbook was corrupt, I tried copying the whole sheet into a
>new workbook, and the validation in the problem column did work for a
>while, but now it's gone again. The other two validated columns continue
to
>work fine.
>
>Help! Is my file just hopelessly corrupt? I'm running this on Mac OSX--
>might that be connected to the instability? Any ideas would be much
>appreciated.
>
>
>.
>

Do you have "frozen panes" and are running Excel 97 - the dropdown will not
work - remove the panes and try again.
--
Regards,

Martin


"Earl Kiosterud" wrote:

> Watson,
>
> If Allow is set to List, then Between should be grayed out. You said it's
> set to "between." If it's not grayed out, something is broken. "I'll take
> 'Things that don't work for $100, Alex.'" I suppose you could deselect Show
> Input Message, since there is none. That might work as well as standing up
> and turning around three times. Does this workbook use User-defined
> Functions (UDF's), by any chance (macros that return a value in a cell)?
>
> Pressing Alt-DownArrow brings up the dropdown, same as clicking the
> (missing) button. Try that on an errant cell.
>
> Other than that, I don't have any suggestions.
> --
> Earl Kiosterud
> mvpearl omitthisword at verizon period net
> -------------------------------------------
>
> "Watson" <anonymous@discussions.microsoft.com> wrote in message
> news:050101c52ee9$8723dfa0$a601280a@phx.gbl...
> I see you got the Holmes reference. Sorry about the delay--I had to leave
> the office for the day. The settings are
> as follows:
> ALLOW: List
> DATA: between
> SOURCE: =$AT$13:$AT$17 (These cells contain the items that should
> appear on the list.)
> IGNORE BLANK is checked
> IN-CELL DROPDOWN is checked
> SHOW INPUT MESSAGE is checked (but there is no message)
> SHOW ERROR ALERT is checked
> TITLE is Error Alert
> STYLE is stop
> ERROR MESSAGE (I won't bore you with the text--it's about 110 characters)
>
> That's it--except for the source cells and error text, the settiings are the
> same as for the others validations that work. Sigh. Any ideas?
>
> >-----Original Message-----
> >My dear Watson,
> >
> >Tell us exactly what the Data - Validations settings are in one of the
> >errant cells are. Look in all three Data Validation tabs.
> >
> >--
> >Earl Kiosterud
> >mvpearl omitthisword at verizon period net
> >-------------------------------------------
> >
> >"Watson" <anonymous@discussions.microsoft.com> wrote in message
> >news:009501c52e51$a16bc370$a601280a@phx.gbl...
> >Hi--
> >I have three columns which have data validation list boxes attached, so
> that
> >when you click on a cell a little handle appears and you select a name from
> >the list box that appears. In one of the columns, however (and always the
> >same one), the handle doesn't show up. When you to type in a cell, the
> >warning box still appears saying that you have to select data from the
> >list,
> >but the handle never appears, making selection impossible.
> >
> >Thinking the workbook was corrupt, I tried copying the whole sheet into a
> >new workbook, and the validation in the problem column did work for a
> >while, but now it's gone again. The other two validated columns continue
> to
> >work fine.
> >
> >Help! Is my file just hopelessly corrupt? I'm running this on Mac OSX--
> >might that be connected to the instability? Any ideas would be much
> >appreciated.
> >
> >
> >.
> >
>
>
>