I've had a lengthy online search for this, but haven't managed to find a solution, so I'm not getting my hopes up here
Within a worksheet, I have a list box, created exactly as in steps 1 & 2 of this link
EDIT: I used a Form control, not an ActiveX control
There are a large number of options in the list box, and so there is a scroll bar to the right hand side.
Elsewhere on the same worksheet, I have a "Reset Inputs" button, which runs a macro which sets all checkboxes, radio buttons, list boxes etc. to the top/default values.
I am able to automatically select the 1st choice in the list box by changing the cell link value to '1'.
If the list box is scrolled down at all (i.e. you cannot see the top choice), then selecting the 1st choice using this macro will not scroll the list box back up to the top.
In other words, the top value will be selected, but you cannot see that it is selected, as the scroll position itself does not change.
I have named the list box, and can select it in VBA by using:
ActiveSheet.Shapes("listbox_serial_subtype").Select
At this time I don't have an example document I can provide - the one I'm using is confidential - but I will create an example one from scratch if required.
Bookmarks