Enable Command Button if ANY of 4 Listboxes Have a Selection Made

Hello Forum and thanks in advance.

I have a fairly straightforward UserForm with 4 listboxes and 4 option textboxes (the textboxes do not need to be a part of the validation I'm needing). I then have a command button that I want to be enabled ONLY if ANY of the 4 Listboxes have a selection. I've tried the "Change" event code below and it works upon the first selection of any listbox item. However, if the user de-selects all selections in the listboxes (i.e. they are all unchecked), the command button remains enabled. I need the validation logic to enable/disable the button to persist as long as the user has the form open and if there is not a selection in ANY of the listboxes. The reason being is that if they click the command button it will update the cells in the worksheet, which if empty may overwrite previous work completed with blank cells.

I'm not necessarily tied to this approach, so other ideas are welcome. Your collective expertise and input is greatly appreciated!

Thanks,
Chris

Please Login or Register  to view this content.

Thanks for the quick reply Greg, but I run into a different variation of the same problem, which I believe exists with using the Change event for the listboxes. Your code works for each listbox in the Frame they reside in (maybe the Frame setup is an important detail I left out), but now if I make a selection in the first listbox and then a selection in the second listbox, the button disables again if I go back and deselect my choice in the first listbox because the change event for that listbox is superceding the event for the second listbox since it appears first in the code. That's how I'm understanding the issue.

Is there a way to code to count the items for ALL listboxes in the frame together or for any value in the frame itself and then apply the enable/disable if/then logic?

Thanks again,
Chris

Here's what I used that's creating the problem described above (only did it for 2 of the 4 listboxes):

Please Login or Register  to view this content.

Deleting duplicate post