ListBox Display

I have populated data on a listbox reading in from current excel and also theirs a delete function in place. I was wondering if its possible, in regards to the listbox when you double click a value on the listbox, it will let you input all the corresponding data it comes with on your userform.

Please Login or Register  to view this content.

code used for populating


Looking at attached file. Run userform
In regular users put in "U403114" then click active requests, it will run the listbox with all the corresponding information
On double clicking that information I want it to write out to the userform in the corresponding boxes
then whatever's it has read in, if i edit one, override the one its reading in


Any help appreciated



The attached file, when you run it, put user id U403114 in the active requests option it populates that data, but what I want after that, whatever data I click on for it to read that data in then override it's current values .