"Dropping Down" ComboBox Created Directly in Workbook using VBA

[sodiii]

I have read many ways of controlling drop-down boxes in a userform
..setfocus, .dropdown, etc.... Does anyone know of a way to instruct a
shape (combobox) to "drop-down" in VBA. I am able to select the shape
as follows but I am really hoping to be able to drop it down so the
user can just click their response at which point I would move focus to
the next field. I may attempt to use a userform for this but the users
are used to the format in the datasheet. I was able to select the
shape with the following line of code....

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

However I have not been able to figure out how to have it open as if
you had clicked on it. Any help would be greatly appreciated!!

Dan

 

[Alex Dybenko]

perhaps it has a DropDown method which you can try to use, like any other
combobox