Hi Guys,
My idea is to read the values from the Excel file and list them in ListBox. The idea is a user reads all currently Open tickets that are stored in a workbook and has them displayed in the list box. Then selects an item he'd like to close and just clicks 'Close' button - the status in the Excel file is changed to Closed.
I need a solution, a loop to go through open items and list them. I don't know how to get the Excel item listed appear in the listbox - this is my main problem.
The result should be as below:
____________________________________________
|Task Name ........................................... | Status |
|Pricing ................................................... | Open . |
|Access Management................................. | Open.. |
|Prepare a report for Dave.......................... | Open.. |
|___________________________________________|
_______
| Close |
|______|
Input data:
<tbody>
</tbody>
Regards,
Witek
My idea is to read the values from the Excel file and list them in ListBox. The idea is a user reads all currently Open tickets that are stored in a workbook and has them displayed in the list box. Then selects an item he'd like to close and just clicks 'Close' button - the status in the Excel file is changed to Closed.
I need a solution, a loop to go through open items and list them. I don't know how to get the Excel item listed appear in the listbox - this is my main problem.
The result should be as below:
____________________________________________
|Task Name ........................................... | Status |
|Pricing ................................................... | Open . |
|Access Management................................. | Open.. |
|Prepare a report for Dave.......................... | Open.. |
|___________________________________________|
_______
| Close |
|______|
Input data:
Task name | Date | Owner | Status |
Pricing | dd/mm/yy | Agent A | Open |
Reconciliation | dd/mm/yy | Agent A | Closed |
Accesses management | dd/mm/yy | Agent B | Open |
Send email to Rick | dd/mm/yy | Agent B | Closed |
Prepare a report for Dave | dd/mm/yy | Agent B | Open |
<tbody>
</tbody>
Regards,
Witek
Last edited: