macro/combo interchange

  • Thread starter Thread starter bruce dickson
  • Start date Start date
B

bruce dickson

I've had a look through the history but there doesn't
seem to be an appropriate
I understand that to fill a combo box on a worksheet from
within a macro you use the code:

ActiveSheet.Shapes("Drop Down 1").ListFillRange = "a1:d1"

.... but how would you then check the value of a combobox
from within a macro?

cheers

Bruce
 
You notation indicates you are using dropdowns (comboboxes) from the forms
toolbar:

With ActiveSheet.DropDowns("Drop Down 1")
msgbox .List(.ListIndex)
End With
 
Back
Top