- 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 =)
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 =)