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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top