Data required in User Form Box based on selection

[RAMU]

Hi Friends,
Pls go thru my attached link carrying my file. I want that I will select any cell of allocated qty column (in "allocation vs rqd" sheet), in that row's item code's entity division(location), item name & godown wise qty should reflect in the same sheet (allocation vs rqd) automatically in a user form in a proper manner. And that data will be fetched from "Stock" sheet.
Even I filer any Data in the "allocation vs rqd" sheet that will not effect on that box , in spite of that if they select any cell of "allocated qty" column earlier that item's data would be reflected in the same sheet ( in the box) that may be a pop up type box or a box can be kept aside where those data will be reflected even that data also should be copied if required.

Suppose I select S15 cell in "allocation vs rqd" sheet, then the data that would be reflected in that box is giving below

Entity Division(Location)	Item Code	Item Name	UM	Godown	Godown Name	Closing Quantity
EL-3	IC7	IN7	PCS	GD8	GN8	6
EL-5	IC7	IN7	PCS	GD9	GN9	433
EL-7	IC7	IN7	PCS	GD7	GN7	6

As in S15 cell is showing data of item Code IC7 & closing qty of that code is available in 3 nos of godown.
Hope You can understand what I mean to say.
It will be a great help if I get a solution on this.
The File

Regards
RAMU

 

[RAMU]

Hi Friends,
Pls go thru my attached link carrying my file. I want that I will select any cell of allocated qty column (in "allocation vs rqd" sheet), in that row's item code's entity division(location), item name & godown wise qty should reflect in the same sheet (allocation vs rqd) automatically in a user form in a proper manner. And that data will be fetched from "Stock" sheet.
Even I filer any Data in the "allocation vs rqd" sheet that will not effect on that box , in spite of that if they select any cell of "allocated qty" column earlier that item's data would be reflected in the same sheet ( in the box) that may be a pop up type box or a box can be kept aside where those data will be reflected even that data also should be copied if required.

Suppose I select S15 cell in "allocation vs rqd" sheet, then the data that would be reflected in that box is giving below

Entity Division(Location)	Item Code	Item Name	UM	Godown	Godown Name	Closing Quantity
EL-3	IC7	IN7	PCS	GD8	GN8	6
EL-5	IC7	IN7	PCS	GD9	GN9	433
EL-7	IC7	IN7	PCS	GD7	GN7	6

As in S15 cell is showing data of item Code IC7 & closing qty of that code is available in 3 nos of godown.
Hope You can understand what I mean to say.
It will be a great help if I get a solution on this.
The File

Regards
RAMU

Hi,
I have made using VBA, but not so satisfied, first it is interrupting to scroll using keyboard until & unless msg box disappear, second not properly & symmetrically showing data in a proper manner, tried using user form but till now not successful. Need a very vibrant one, so that if I select a cell & time value will be 2 sec, then only the message will appear, better if someone can help me to get it done using user form & data in a proper manner or any other suggestion which will be more effective in this journey. Moreover there will be a shortcut key in the user form to close that not by mouse click only.
Giving the link of my modified file that I did.
Regards
RAMU
The File

 

[RAMU]

Any alternated suggestion on this pls