Unhide 2nd Listbox when condition is met in the 1st multi-select listbox

Hello,

I have been working this for a little bit now and not having much luck. I have a userform with 2 listboxes, both multi-select. When the form initializes, I have the 2nd listbox set visible=false. I am attempting to get listbox2 property to change to visible=true if listbox1 has "Electromyography (EMG)" selected with or without any other choices in listbox1.

This is what I have that doesn't seem to work.

Please Login or Register  to view this content.

Thanks for your help.

Patrick

Hi Patrick,

Your code worked for me exactly as you wrote it.

My speculation is that the actual value in the list box is NOT "Electromyography (EMG)" exactly. You probably have a leading or trailing space, or an extra embedded space or an extra Upper or Lower case character.

Try the following which is included in the attached sample workbook.

Please Login or Register  to view this content.

Lewis

Thanks for the help Lewis. It appears however, that because my listbox is set to be a multi selection control, the code you sent will not work for this situation. I have been reading up a bit on this. I have yet to find a way to do this that I can truly wrap my head around. From what I see, I need to use a selection property that works with an index or array for the data in the listbox. My choice of interest ("Electromyography (EMG)") is in the 2 index position (3rd down from top). When the EMG selection is made, with or without other selections, is when I would like listbox2 to show itself.

Any ideas on how to accomplish this?

Thanks,
Patrick

It does what you want but it's not optimum, because it depends on EMG being the 3rd item.

Try the following which will work for a Single or Multi Selection ListBox:

Please Login or Register  to view this content.

Yep. I like your code better. Thanks for the help Lewis.

Patrick