🔔 Subscribe to my YouTube channel / @sobanan19 Excel File Download Link (with VBA coding): https://koji.to/k/9Tla QUOTE START ................................................................. IF YOU ADD NEW CATEGORY then, open frmSalesInvoice Please write below 4 line coding in the Private Sub cboCategory_Change() event above the Case Else and make changes as per the comment ..... Case "Vegetable Item" ' CHANGE THE CATEGORY NAME For iRow = 2 To ThisWorkbook.Sheets("Product List").Range("A1048576").End(xlUp).Row .AddItem ThisWorkbook.Sheets("Product List").Cells(iRow, 16).Value 'CHANGE THE COLUMN NUMBER Next iRow NOW, COPY THIS 4 LINE AND PASTE IT IN THE frmProcurement - Private Sub cboCategory_Change() above the Case Else . ................................................................. QUOTE END SALES INVOICE SYSTEM PROCUREMENT MANAGEMENT SYSTEM CUSTOMER DATABASE SUPPLIER DATABASE EMPLOYEE DATABASE EXPENSE DATABASE VEHICLE MANAGEMENT SYSTEM USER LOGIN CALENDAR or DATE PICKER Note: If you want to Cancel any invoice in the SalesInvoice, first you need to view the invoice. Note: To save the invoice as pdf, you need to prepare a folder and assign the folder name in the frmSalesInvoice under the cmdSaveAs PDF and cmdEmailAsPDF. I made comment in both places. You can find easily. ♦️See the playlist • Excel VBA Project Sobanan_Knowledge_Sharing #Excel #Email_Automation #Estimation #Construction #Calendar #Date_Picker #Student_Management_System #University_Database #User_Login #User_Form #Automated_Invoice_System #Stock_management #Calculator #Excel_VBA_Project #VBA #Project #Kanban #Variance #Advanced_Search_Function #Risk_Assessment_Matrix #KPI #Clustered #Column_Chart #Dynamic #Actual #Target #Budget #World_Map #Financial_Statistics #Statistics #Sales_Dashboard #Dashboard #InfoGraphics #BarChart #4QuadrantChart #Business_Presentation #Sobanan_Knowledge_Sharing Super Market Invoice & Stock management System | Excel VBA Project