Userform force sequence

[brianfosterblack]

I have a problem in my userform that my selection in listbox2 determines if listbox3 or listbox4 becomes visible. However if after listbox1 I click on listbox3 or 4 (whichever is visible) I get an error in my code because I should have selected in listbox 2 which listbox is actually visible.
Can I remove any selection accidently made in listbox3 or 4 and force setfocus onto listbox2 first when I click off listbox1 or can I in the userform code, force that all 6 listboxes must be selected in order 1 to 6 with the option that either listbox3 or listbox4 will be hidden depending on my selection in listbox 2

 

[pjmorris]

in the code for LIstbox2 you can select the visibility of the other listboxes - and in the initiating code you can hide any which are not immediately valid.

HTH

 

[diddi]

hide all but the first listbox. then show them as you intend them to be used. you can even have the previous ones disabled but with selections showing and include a back button which then controls all the user behavior. a bit more work but "dumbproof" in the long run

 

[brianfosterblack]

in the code for LIstbox2 you can select the visibility of the other listboxes - and in the initiating code you can hide any which are not immediately valid.

HTH

Simple answer but it resolves the problem perfectly - Thank you