Userform Listbox selection to textbox

[colin7]

I have a listbox on a userform (lboProjects) which has a list of projects. When I select a project I want a textbox (txtboxprojectnames) on the userform to equal the selected name.

I have tried a few codes but haven't managed to get it working. Any help would be greatly appreciated!

Please Login or Register  to view this content.

[Rick Rothstein]

REVISED POSTING
------------------------------------
I don't think you need the MessageBox because the user cannot remove the selection in the ListBox once it has been made. If you want, you could pop the MessageBox in the UserForm's Initialize event but you would need to change the message to something like "Please make a selection from the ListBox" or some other indicator that an action is required. As for putting the value in the TextBox, this should be sufficient...

Please Login or Register  to view this content.

[colin7]

Rick,

Thanks for taking the time to help me.

That works perfectly..cant believe it was something so simple.