I have read in this forum about ways of controlling drop-down boxes
created in a userfrom (eg .setfocus, .dropdown, etc...) Does anyone
know how to "drop-down" a shape (combo-box) created directly in a
workbook? I am hoping to cause the combo-box to drop down as if it had
been clicked by the user, then once they make a selection, I was hoping
to move focus to another input field. I may consider using a userform
to accomplish this, but the users of this spreadsheet are used to the
current format where boxes are located directly in the worksheet. I
was able to select the shape/combobox using the following line of code;

ActiveSheet.Shapes("Drop Down 9").Select

but am not able to get it to drop down as it would if the user had
clicked on it. If anyone could point me in the right direction as far
as what functionality or code topic in excel I should be reading up on,
it would be greatly appreciated. Thanks!!

Dan