macro/combo interchange
 

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

macro/combo interchange
 

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

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

--
Regards,
Tom Ogilvy


"bruce dickson" wrote in message
...
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