Check if 2 consecutive Form listbox items selected

Hi,

Can someone show me how to test if 2 consecutive list-box items are selected.

Criteria is that only 2 consecutive items must be selected to proceed.

Thanks

please post a sample sheet illustrating what you are trying to do.

If I can plagiarise Davesexcel code and make some minor changes, this will check for consecutive

Please Login or Register  to view this content.

Thanks

Dave & MallyCat

@MallyCat - objective is that in a workbook there is x amount of sheets named eg: 26th Mar Wk 12 , 2nd Apr Wk 13 , 9th Apr Wk 14 , 16th Apr Wk15 ...etc
Application workbook 1st lists each of these sheets in a list box and the user must select 2 consecutive sheets that follow each other eg: 2nd Apr Wk 13 & 9th Apr Wk 14
as these sheets are then imported into application workbook, and data from these sheets are used for a specific purpose.

Yes MallyCat, I realise that a sample helps but sometimes a response maybe be given without the need of such.

In this case I would think it was not required..

But then you may say that somebody may have a completely different approach to what I am trying to do, then in that case I would..

Thanks Guys

Ok Dave didn't mean to upset anyone.

I was thinking a question may produce a answer and then the next step of a sample.

The listbox consecutive selection was the focus not the worksheets

If you request then I shall supply

Regards

Thanks Jerry

I appreciate your response.

I will try your approach in the real world Monday..


Regards

Thanks Andy for your solution. I will test that one out ASAP.

Jerry - your solution works - thank you again.

Regards