Userform Multi-Select Listbox Selection Condition to unhide Frame and controls

**pjbassdc** · 10-31-2016, 10:00 AM

Hello Everyone,

I am working on a userform with a multi-select listbox (ListBox2) which is populated from a named range (item index is 0-19) . I would like, on exiting the listbox, for the selections to be checked that if any items in index position 4 to 16 are marked, to unhide a Frame with some other controls (Frame_Muscles) . If index 4 to 16 is not chosen but something else is, the other listbox would remain hidden. I have been looking around without much success. Any help is appreciated

Thank you,

Patrick

**mikerickson** · 10-31-2016, 10:05 AM

Some thing like this should work. Perhaps in the ListBox2_AfterUpdate event.

Please Login or Register  to view this content.

Userform Multi-Select Listbox Selection Condition to unhide Frame and controls

LinkBack

Thread Tools

Rate This Thread

Display

Userform Multi-Select Listbox Selection Condition to unhide Frame and controls

Re: Userform Multi-Select Listbox Selection Condition to unhide Frame and controls

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Loop through userform frame controls

[SOLVED] Looping through controls by frame on userform (frame within a frame)

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

[SOLVED] Clear UserForm Multi Select ListBox

[SOLVED] userform Multi select listbox - add contents to list

Multi select Listbox Items selection based on other Listbox item selection.

Creating Userform Controls on Frame

Bookmarks

Bookmarks

Posting Permissions