Ticket_Tracker_System_Macro 💻

VBA is one of the top 5 programming language; old but gold, I did created a VBA Excel Ticket Management System that keep records of ticket status and Help to reduce the tracking workload of incident / minor cases Feel free to play with code :)

1. This is how entire Macro form looks like 🎉

1_launch.mp4

2. Main feature of Ticket Management tool is:

• Perform CRUD- CREAT READ, UPDATE AND DELETE operation on database 📝
• Perform data validation 🎌
• • Show custom icons and calendar window 📅
• Display recorded data in charts and graphs. 📊

3. Create a new record: 🗒️

• Creating/Insert new record

👇

2_create_data_V1.mp4

• I purposly 💡 left the 'Comments field' empty because in step-4, we will update the comment textbox

2_create_data.mp4

4. Update existing record.

In step-3, we left comment section empty, this time, comment textbox will be have a data (In short: update operation is performing ⭐ )

In Order to update data, double click (WE are updating Primary key/ ID number:6 row comment field) is required on selected row and existing fields will populate with selected data with respect to fields:

3_update_data_V1.mp4

5. Delete a row record 👇 ❎

5_delete.mp4

6. Sort rows in Ascending and Descending order based on user input in search box: 👨‍🔬

06_sort_ASC_DSC.mp4

7. Search Data according to Columns name using Refresh button:

5_search.mp4

8. Reset Button to reset all input textbox and combo box fields:

reset_button.mp4

9. Export a selected row to new Excel workbook sheet ⚔️

TicketTracker.online-video-cutter.com.mp4

10. Upcoming feature: Data visualization through Graphs and Charts 📢