How to Open a ListBox with VBA (1 Viewer)

I have two ListBox. LB1 is a Category selector, LB2 is a SubCategory selector. If the User changes the Category choice from LB1 a whole new set of Sub Categories must be updated to LB2 recordset. I also want the focus to go immediately to LB2. I can do all that with VBA, no problem.

When a user select a ListBox extender arrow for changing the selection
the ListBox unfold and the scrolling slider extend.

How can I programmatically unfold the ListBox and it's scrolling slider ?

Fred,

What have you tried? What result?

You may find some ideas/insight/options in this Martin Green article.

Good luck.

What I have done so far is quite easy. Anytime a user changes the Category ComboBox value I use VBA with a simple SQL query to update the SubCategory ComboBox recordset.
My problem is not that it doesn't work, In fact, it works pretty well!
What I want to do is when the user changes to Category ComboBoxI wnat VBA to focus on the SubCategory ComboBox (easy) then Expand automatically the ComboBox just like it does when you click on the triangle to expand the box with a mouse. With all the Methods, properties and events available with those controls, there's got to be a way to expand that ComboBox programmatically ?

Yeah, check out the ComboBox.Dropdown method.

Now I really feel ashamed