Start value of dropdown

Joined
Aug 3, 2010
Messages
2
Reaction score
0
Hello, i have a dropdown on the list, i created it with
Sht.DropDowns.Add()

it has a property .OnAction = "ch_vall" , which change the value of the some cell to the value of chosen list item:
Private Sub ch_val()
With ActiveSheet.DropDowns(Application.Caller)
Sht.Cells(1,1l) = CStr(.List(.ListIndex))
End With
End Sub

PLs, help me: How i can set automatically the value of the dropdown with calling .OnAction procedure

P.S. sorry for my english =)
 
Back
Top