Selection position in a userform

[Giordano Bruno]

I have a userform listbox for about a hundred items of which twenty fit into the listbox window, I use the below code to preselect one of the items
.lbxItems.ListIndex = ItemIndex
This highlights the selected item, but positions the items shown in the listbox with my selection being the last visible row. Typically I will want to select one of the items below the selected item and I would prefer that the selected item were shown half way down the listbox to avoid my having to scroll down to see the lower items. Is this possible?

 

[diddi]

try selecting (itemindex + half the items count you display in the listbox) first. then unselect and select the item you really want. its a dodgy idea, but might work

 

[Giordano Bruno]

Hi diddi,
Thanks for the reply It sounds perfect. Do you mind telling me how to do it?

 

[Giordano Bruno]

OK. I've found the answer.
.lbxItems.TopIndex = ItemIndex + 6
Oddly enough, making the top index equal to the ItemIndex doesn't put the selected item at the top. Nevertheless, I've fixed my problem, but thanks diddi for you interest.