Mohammad Ishaq
Member
Hello everybody
I have an excel file with the follwoing objects.
1.First sheet named Data1
2.Second sheet named WHT
3.Tird sheet named Transportation
One user form having two pages (Invoice Entry and Payment Entry)
Two List boxes on each page.
My concern is with the 2nd page i.e payment entry.
My first question is that how to enter payment information from text boxes for one or more invoces on the selection from the list box.
I mean that when i select one or more invoces from the list box then the payment date and cheque no entered in the payment section of that invoices.And also i want the unpaid
status change to paid and similarly the same inv no and amount auntomatically show in the payment section.
For better understand i have attached the image and file.
Please let me guide , i will be very thankful to you.
I have an excel file with the follwoing objects.
1.First sheet named Data1
2.Second sheet named WHT
3.Tird sheet named Transportation
One user form having two pages (Invoice Entry and Payment Entry)
Two List boxes on each page.
My concern is with the 2nd page i.e payment entry.
My first question is that how to enter payment information from text boxes for one or more invoces on the selection from the list box.
I mean that when i select one or more invoces from the list box then the payment date and cheque no entered in the payment section of that invoices.And also i want the unpaid
status change to paid and similarly the same inv no and amount auntomatically show in the payment section.
For better understand i have attached the image and file.
Please let me guide , i will be very thankful to you.
