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