macro/combo interchange

[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

 

[Tom Ogilvy]

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

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