Question about list box using excel vba

[Mohammad Ishaq]

I have an excel sheet(sheet1) having some data.In the sheet i have seven columns.On the other hand i have a user form with two text boxes ,a save button and a list box with multi select option, populated with the data from my sheet(sheet1).

After single or multi selection of rows when i enter the date and cheque no using the text boxes and save button,
i want the following result

1.In third column the payment statu should change from Unpaid to Paid.
2.The Amount in fourth column should apear in sixth column.
3.The cheque no should apear in seventh column of selected rows.


I have upload an image and file .

Please guide me to solve my problem.

 

[charlesdh]

Hi,
I changed the way you had your file set up. I removed the "List" and used a "Double Click" method to show userform which I revamped your form.
All yo need to do is Double click the Invoice you wish to update. Fill in the data in the userform that is displayed and the click the button. The file will be updated. The userform will hide so that you can make another select.

Charles

 

[Belleke]

Perhaps like this?
See attached.

 

[Mohammad Ishaq]

Yes,it is very useful.Thanks