Data Validation

[Guest]

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

 

[Guest]

Daniel

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

Mike R.
HTH

 

[Debra Dalgleish]

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

 

[Guest]

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.
(e-mail address removed)

Thanks
Daniel

 

[Max]

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

 

[Dave Peterson]

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]

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

 

[Dave Peterson]

Thanks for the link.

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

 

[Max]

You're welcome !