Userform help

[Benjamin.Welch]

Good Morning guys, I hope you're doing well today!

I have a UserForm thatt consists of a listbox that has data populated within it using the ListIndex procedure.
So far when the list is displayed, you recieve a list of funds to choose from. When the user selects a fund it takes them to a different sheet when this information can be accessed.

I was curious on how to code a line where when the user selects a funds and presses "Search" it displays another UserForm dedicated to that funds.

The Second UserForm consists of nothing but a textbox where the name of the fund will be displayed and a massive textbox that's empty.

If someone could help me out it'd mean the world for me!

Thank you so much for your time and reading xx <3

[Benjamin.Welch]

Hey I've made a listbox that has a rowsource that displays funds my company uses.

I'm stuck on trying to get another Userform to show after a selection from the listbox is made.

Can someone please help.

Please Login or Register  to view this content.

Heres what I've been trying

[sintek]

Something like this...

Please Login or Register  to view this content.