VBA List box to choose the right user form depending on the selction

[rv02]

Hi All

I have a quick query which Im sure it be easy for someone with good knowledge of VBA.

I have attached a very simple spreadsheet to explain what I need to do.

I was the user form which I have created to show a list of names and depending on the selection of the name opens up another form for that person with some command buttons which the user can choose to navigate through the appropriate sheets.

In the example I have attached, If I choose Frank, I need the user form Frank to open so Frank can navigate from his user form. I have set everything up properly but need to know the code for list box selection item to open the right user form.

Hope I am clear in what Im trying to do.

Thanks in advance

[sktneer]

I don't have a good knowledge of VBA so not sure if I am eligible to answer your question, but in this case I would like to trigger a double click event for list box instead of having a command button on the userform1.

You may try something like this.....

Please Login or Register  to view this content.

Or you can place a command button as per your requirement and place the following code inside the button click event.

Please Login or Register  to view this content.

[rv02]

Thanks, this works great. I appreciate your help