Changing cell on button click pulling information from a ListBox

Hey everyone,

I'm trying to run a dashboard with 3 different tabs as display and 1 tab as database.
Each display tab has a dashboard containing a ListBox and 3 TextBoxes. The List receives the data from the Database tab and the TextBoxes receive it from the List.
One of the TextBoxes displays status "ONGOING" or "DONE".

What I want is to add a button that, upon clicking, changes the information from "ONGOING" to "DONE" in the Database and consequently in the List and TextBoxes, for the selected item in the ListBox.

Meaning if I select the third Item in the List, the command has to alter the information in the correct row in the Database table.

Can someone help me out with the code to that button?


Additional info:
- Each List on each Tab has a defined range within the Database table, it is not dynamic, it has been added directly to the ListBox properties.
e.g. ListBox 1 ranges from A2:E27; ListBox 2 ranges from A28:E35 and so on...

- The Done or Ongoing status is contained in the E Column of the Database.

Thanks for the support!

Reposted from < MrExcel forum under #post5302564>

As you have more than 10 posts you should be able to post a link to your cross post.
Please add the link. Thanks

It is always helpful if a prototype of the actual file is loaded within this thread so other can take a look and give you advice or solution.