Data Validation
 

I'm encountering a frustrating problem relating to data validation, and I'm
sure there's a simple answer.

On one sheet only, when I set up Data Validation (sourcing a list), the
little dropdown arrow to the side of the cell doesn't appear.

On all other sheets, the dropdown appears.

On the problem sheet, the validation still works (ie, I can't enter a value
that isn't on the list), but the dropdown doesn't appear.

Any ideas?

Thanks in advance.
Daniel

Daniel

Select the cell where the drop down should be, then select data
validationsetting tab, and make sure "in-cell dropdown" is check marked.

Mike R.
HTH

"Daniel Bonallack" wrote:

I'm encountering a frustrating problem relating to data validation, and I'm
sure there's a simple answer.

On one sheet only, when I set up Data Validation (sourcing a list), the
little dropdown arrow to the side of the cell doesn't appear.

On all other sheets, the dropdown appears.

On the problem sheet, the validation still works (ie, I can't enter a value
that isn't on the list), but the dropdown doesn't appear.

Any ideas?

Thanks in advance.
Daniel

Are the dropdowns in a frozen part of the window?
In some versions of Excel, that will affect the data validation dropdowns.


Daniel Bonallack wrote:
I'm encountering a frustrating problem relating to data validation, and I'm
sure there's a simple answer.

On one sheet only, when I set up Data Validation (sourcing a list), the
little dropdown arrow to the side of the cell doesn't appear.

On all other sheets, the dropdown appears.

On the problem sheet, the validation still works (ie, I can't enter a value
that isn't on the list), but the dropdown doesn't appear.

Any ideas?

Thanks in advance.
Daniel


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Yes, I have a check mark there. I still don't have the dropdown. Also,
Freeze Panes is off, and the workbook is not protected, nor are any cells
locked.

I'm really stuck, so if you have any other ideas, I'd be delighted to hear
them.


Thanks
Daniel


"Mike R" wrote:

Daniel

Select the cell where the drop down should be, then select data
validationsetting tab, and make sure "in-cell dropdown" is check marked.

Mike R.
HTH

"Daniel Bonallack" wrote:

I'm encountering a frustrating problem relating to data validation, and I'm
sure there's a simple answer.

On one sheet only, when I set up Data Validation (sourcing a list), the
little dropdown arrow to the side of the cell doesn't appear.

On all other sheets, the dropdown appears.

On the problem sheet, the validation still works (ie, I can't enter a value
that isn't on the list), but the dropdown doesn't appear.

Any ideas?

Thanks in advance.
Daniel

FWIW, the phenomena sounds familiar, re this discussion with Dave Peterson
some 9 months back: http://tinyurl.com/5k48m

Hope you have a recent back up prior to the event occuring ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

This doesn't help the OP, but there is a current thread in .excel that discusses
the same kind of problem.

Bob Phillips showed a way to save those dropdowns when you're deleting shapes.

The subject is: Drop down list missing.

This was the last post (well, so far):


Maybe you can test the .topleftcell address. Those data|validation dropdowns
don't seem to have one.

Option Explicit
Sub testme()

Dim shp As Shape
Dim testStr As String
Dim OkToDelete As Boolean

For Each shp In ActiveSheet.Shapes
OkToDelete = True

testStr = ""
On Error Resume Next
testStr = shp.TopLeftCell.Address
On Error GoTo 0

If shp.Type = msoFormControl Then
If shp.FormControlType = xlDropDown Then
If testStr = "" Then
'keep it
OkToDelete = False
End If
End If
End If

If OkToDelete Then
shp.Delete
End If

Next shp

End Sub

And this saved the autofilter dropdown arrows, too. (Still beating that
horse!).

I like this one, Bob.

Max wrote:

FWIW, the phenomena sounds familiar, re this discussion with Dave Peterson
some 9 months back: http://tinyurl.com/5k48m

Hope you have a recent back up prior to the event occuring ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

--

Dave Peterson

"Dave Peterson" wrote

This doesn't help the OP ..
And why not <g ? It always lightens things a little knowing
there's others out there who had suffered before ...
(sometimes they call it "empathy")

For the OP: Here's the switch to the thread
that Dave mentioned: http://tinyurl.com/4gtfr

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

Thanks for the link.


Max wrote:

"Dave Peterson" wrote

This doesn't help the OP ..
And why not <g ? It always lightens things a little knowing
there's others out there who had suffered before ...
(sometimes they call it "empathy")

For the OP: Here's the switch to the thread
that Dave mentioned: http://tinyurl.com/4gtfr

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

--

Dave Peterson

You're welcome !
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----