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