Listbox Click

[pure vito]

Hi All,

If anyone can provide help I’d be very grateful,

I have two user forms the first “people” the second “roles”

Within the user form “people” I have a textbox “nameinput” that I input names into and doing this brings up data within that user form for that name,

Within the second user form “roles” I have a list box “names” populated with all of the names, I would like to be able to click a name within the list box and have it bring up the user form “people” and have the name selected paste into the text box “name input” I'm not sure if this is possible but a have done something similar in the past,

Hope this makes sense and again appreciate any and all help

 

[Herakles]

Hi All,

If anyone can provide help I’d be very grateful,

I have two user forms the first “people” the second “roles”

Within the user form “people” I have a textbox “nameinput” that I input names into and doing this brings up data within that user form for that name,

Within the second user form “roles” I have a list box “names” populated with all of the names, I would like to be able to click a name within the list box and have it bring up the user form “people” and have the name selected paste into the text box “name input” I'm not sure if this is possible but a have done something similar in the past,

Hope this makes sense and again appreciate any and all help

Put this code in the names userform code module.

Private Sub names_Click()
    
    people.Show
            
    people.nameinput.Value = roles.names.Value
    
End Sub

 

[pure vito]

Fantastic thank you Herakles that's exactly it!,

Is it now possible to trigger the search button that is in the user form "People" with each click, I'm guessing it's not a simple call?

"resetadd" is the macro within the "People" user from could you possibly add this to the code please

 

[Herakles]

Fantastic thank you Herakles that's exactly it!,

Is it now possible to trigger the search button that is in the user form "People" with each click, I'm guessing it's not a simple call?

"resetadd" is the macro within the "People" user from could you possibly add this to the code please

You don't need to trigger the Search button but just run the code behind the Search button when the value in the textbox changes.

Put this code in the people userform code module.

Submit your code in the people userform sung the VBA Quick-Wrap selection option on the Mr Excel ribbon if you have any problems

Private Sub nameinput_Change()
    
    ' add our code here.
    Call SearchButtonCode
    
End Sub

 

[pure vito]

Thank you Herakles this was throwing up an error but i'll try to sort it out thank you very much for your help