CLICK EVENT IN A LISTBOX1 TO DISPLAY VALUES ON ANOTHER LISTBOX2 IN ONE FORM

Dear Masters,

I have this inventory tracker excel file, that has use form for my search function (see attached image)

I have a combo box for search option, the result will display in 2 separate listbox one is the AVAILABLE STOCK and the other one is SEARCH RESULT - PRODUCT MOVEMENT.

I have this 3rd list box, in which I wanted to have the values when I click 1 of the result from listbox in Search Result - Product Movement. Values for these list box will come a different sheet (RRBS_List)

Example, When I search for a particular Part Number, results on Search Result - Product Movement will display, and when I click one of the result, the values will populates the third listbox.

I hope I made my explanation clear.

Thanks in advance for those who will take time to answer this queries.

I have attached my sample project. This has been a work in progress.

Quote from royUK

That's much easier to do with formulas on a worksheet.

Attach the example to the Forum post. The reson is explained in the Forum Rules which you agreed to and need to read.

I'm so sorry for breaking the rules Roy.

I totally forgot about links and cloud drives. My file is too large, please let me know how can I upload it. Thank you,

Again my apology for breaking the rules.

Quote from royUK

Try zipping it.

I tried Roy, but still its more than 2MB.

I guess I cant do anything about it.

Thank you tho for the quick response, and again I'm sorry for breaking the rule.

More power to you all.

Y'all are so amazing.

I tried again, but still unable to upload it. The file is more than to 2mb.

Thanks anyway,

Thank you for your help.

Quote from royUK

I've reported the issue if you want to try later.

In this instance you can use a link and I'll look at it.

Thank you so much Roy.

Thanks for being so accommodating.

You're awesome

Here's my project

Google Drive stellt sich vor – Alle Ihre Dateien an einem Ort

Sorry about that, Already granted the access.

Thanks again.

You’re the best.

Quote from royUK

Why are you using an xltm file?

Hi Roy,

I must've saved it in xltm.

My original file is .xlsm.

What should I do then.

I am so sorry for the ignorance, I did not have proper education regarding this, I am only learning this thru various youtube videos and help from other excel masters like you guys.

Thanks,

Quote from royUK

I'll take a look later.

The file uploading issue should be fixed now

Thank you so much Roy.

You're the best.