ComboBox -- Auto open?

[Ed]

Is there any way to cause VBA to automatically drop down a ComboBox? I have
a combobox that contains choices, the selection of one will call for a
reread of the contents to display a set of new choices (cascading-style).
But each time the new data is called for, the ComboBox rolls up and the user
has to click the list down again. Not a lot of work, but a little
disconcerting (there is no 'confidence' that the requested action has been
accomplished until the list is re-opened).

Is there any way to cause the ComboBox to automatically open up?

--Ed (in Virginia)

 

[Doug Robbins - Word MVP]

With .ComboBox1
.DropDown
.ListRows = .ListCount
End With


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[Ed]

Doug,

I have tried the ".DropDown" command. It works, but that as soon as the
sub finished, the ComboBox rolls back up. (I can see the .DropDown dropped
down when I step through the commands, but as soon as the "End Sub" line is
hit, it rolls up.) This is not a sub nested in another routine. When the End
Sub line is processed, there is no more for processing, so I cannot put the
proposed code any later in the routine.

FWIW, this ComboBox is in a UserForm and the UserForm remains visible
the whole time.

Close, but not quite there.

--Ed (in Virginia)

 

[Doug Robbins - Word MVP]

Maybe you should consider using a Listbox instead of a combobox.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com