Scrollbar - Linking to a Combobox

On a userform, is there a way in which to set a scrollbar's slider postion to the ListIndex value of the item chosen in a ComboBox?

In other words, if the total ListCount for this choice is is ten, and the item chosen in the Combobox is in the fourth position, can the scrollbar slider automatically be set to the fourth position rather than be all the way to the left or right?

I would think that this would make it visually easier for the user to understand in which direction they can scroll the list.

Here's what I've got so far:

Please Login or Register  to view this content.

I've attached an example workbook for reference

Thanks in advance.

The use of the line...

Please Login or Register  to view this content.

at the end of ComboBox1_Change() might help. I couldn't grasp completely what you are trying to acheive, especially as you had code which was triggered by change in the value of ScrollBar1 which appeared to reset its maximum.