validate list xl2000
 

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

fax 972-4-8776654



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

validate list xl2000
 

Chaim: Did you mean to set your validation list range as j11:j13? Or
should it be j1:j13? ($J:1$J13)

Ed

"haim rozent" wrote in message
...

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

fax 972-4-8776654



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

validate list xl2000
 

should it be j1:j13? ($J:1$J13)
Sorry - should be ($J$1:$J$13).

Ed

"Ed" wrote in message
...
Chaim: Did you mean to set your validation list range as j11:j13? Or
should it be j1:j13? ($J:1$J13)

Ed

"haim rozent" wrote in message
...

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

fax 972-4-8776654



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

validate list xl2000
 

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.


haim rozent wrote:
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

fax 972-4-8776654



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


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