Extract values from drop-down boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Hi Chris,
what kind of checkboxes did you create. did you use data validation or
controls?
Frank
 
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.
 
Back
Top