DeepBlue1
01-03-2021, 10:37 AM
Hi everyone,
First of all, Happy New Year !
I'm reaching out because I'm stuck in my coding. Indeed, you'll see in the picture that I've set up a tool able to issue release/return vouchers for equipment rental.
Command Button 1 enables you to create a release voucher and Command Button 2 a return voucher.
When clicking on number 2, you have to choose which Delivery Ticket (DT) is concerned by the return and indicate whether the equipment was used and when it came back.
MY PROBLEM: I don't know how I could link the ticket number to the empty cells "used" and "date of return" from the corresponding line. Through CommandButton2 you can select the right DT. After validating, I would like the two cells mentionned aboved filled in the corresponding line.
Home Page picture with "Used" and "Date of Return" cells empty
https://i.stack.imgur.com/nNy5m.png (https://i.stack.imgur.com/nNy5m.png)
CommandButton2 userform
https://i.stack.imgur.com/Y9AgW.png (https://i.stack.imgur.com/Y9AgW.png)
I would like to write a code similar to the one for Command Button 1 but without List_order since there's no ListBox in the second userform. Corresponding file is attached.
27673
Thanks a lot.
First of all, Happy New Year !
I'm reaching out because I'm stuck in my coding. Indeed, you'll see in the picture that I've set up a tool able to issue release/return vouchers for equipment rental.
Command Button 1 enables you to create a release voucher and Command Button 2 a return voucher.
When clicking on number 2, you have to choose which Delivery Ticket (DT) is concerned by the return and indicate whether the equipment was used and when it came back.
MY PROBLEM: I don't know how I could link the ticket number to the empty cells "used" and "date of return" from the corresponding line. Through CommandButton2 you can select the right DT. After validating, I would like the two cells mentionned aboved filled in the corresponding line.
Home Page picture with "Used" and "Date of Return" cells empty
https://i.stack.imgur.com/nNy5m.png (https://i.stack.imgur.com/nNy5m.png)
CommandButton2 userform
https://i.stack.imgur.com/Y9AgW.png (https://i.stack.imgur.com/Y9AgW.png)
I would like to write a code similar to the one for Command Button 1 but without List_order since there's no ListBox in the second userform. Corresponding file is attached.
27673
Thanks a lot.