S
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
..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