Selected Data In Listview To A Textbox And Update It - Excel

[Muaz]

I make one form in Excel having ListBox, When I click on the record the details are shown on the text boxes on the same form. Up to this I have done.

After the data in the text boxes changed/update the record should be updated in Excel sheet after pressing Button "Update".

Any help/idea ?

Thanks

 

[Rx_]

Too many options... are you using a Buddy Control? The list from a cell with Data control?
Can you post a small Excel workbook with a tiny amount of data and leave notes as to the goal?

 

[Muaz]

Hi Rx_

The excel file is attached with some data. The reason behind is we have different site, we are collecting employees attendance, per day, information in excel format. But when we receive that excel sheet that exists plenty data entry mistakes. To reduce and control the amount of mistakes, I become with the idea to make an excel file that contain employee records. Everyday the user will update the same record through form.

Our month start with 16 of every month and end with 15 of next month. Each day have three types of Entry. First text box with Present/Absent (P or A), Second text box with number of overtime hours and Third text box with Night overtime hours. These entries will further be restricted.

Thanking you in advance.

Muaz