Extract values from drop-down boxes

[Chris]

Hi, there
I created drop-down boxes with 5 options for people to choose. Do you know how I can extract the chosen values from the drop-down boxes so that I can run a calculation
Thanks a lot!

 

[Frank Kabel]

Hi Chris,
what kind of checkboxes did you create. did you use data validation or
controls?
Frank

 

[Chris]

Hi Frank,

Thanks for responding. I used control box and wrote the following code.

Sub Control_on_Worksheet()
Dim mypick As Variant
With Worksheets("Functional Survey").DropDowns("my control")
' Set the value of mypick to the index number
' of the item chosen in the drop-down.
End With
End Sub

Thanks again.