Force consecutive selection in muti-select list box

[rkmaitra]

Hello,
I have a multi-select list box in one of my forms. I want to make sure the user selects consecutive items instead of non-consecutive items (e.g. 1-5 instead of 1, 4, 5). Essentially, for this list box, I would like the 'Shift' button to remain pressed (if you see what I mean). Is there a vba code to ensure this? Many thanks for your help,
Rudra

 

[gemma-the-husky]

an easy solution would be to have two combos/listboxes

one to select a range start, and the other the range end.