validate list xl2000

  • Thread starter Thread starter haim rozent
  • Start date Start date
H

haim rozent

hi !
I apriciate your help about validate list.
I creat a macro to build a validate list, but
when I open this validate List it dos'nt start on
the top but in the middle and I have to move the ligule up
every time I open it
how can I change this situation

this is the macro

Sub Add_Validate_List()
ActiveCell.Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop,
Operator:= _
xlBetween, Formula1:="=$J$11:$J$13"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
End Sub

can you help me whithin the macro or whatever ?

thank you
chaim rozent
(e-mail address removed)
fax 972-4-8776654
 
Chaim: Did you mean to set your validation list range as j11:j13? Or
should it be j1:j13? ($J:1$J13)

Ed
 
Is there a blank cell in the range J1:J13?

When you open the Data Validation dropdown list, it takes you to the
first item that matches the cell contents. If the cell is blank, and
there are blank cells in your data validation source list, the first of
these will be selected in the dropdown list.

To prevent this, remove the blank cells from the data validation source
list, or have a default entry in the cell, and the list will open to
that item.
 
Back
Top