Changing cell on button click pulling information from a ListBox

[Boechat]

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!

EDIT:
Also posted https://www.excelforum.com/excel-pr...click-pulling-information-from-a-listbox.html

 

[DanteAmor]

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!

EDIT:
Also posted https://www.excelforum.com/excel-pr...click-pulling-information-from-a-listbox.html

You can upload a file and explain the current operation of your listbox with an example.
Additional question, the listbox is in a userform?

You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.