Spreadsheet into a Program

Going straight to the point. Video shows a simple Spreadsheet with macro codes to summarize a list, and the incorporation of a UserForm to make the Spreadsheet into a program. (you may not have the same list as the one here, but the purpose is that some of the code and techniques can be useful to you on your own programs). The list used here is a Bill of Material type of list. Notes: -To get the totals in Column "E" for this spreadsheet, just create a formula at the beginning of the list such as: =B2*D2 and drag down -Columns "B", "D", "P" and "R" are Currency Formatted -Cell "AA1" keeps the count of the number of items in the list; and so if items are erased at the spreadsheet, then change the value of "AA1" cell (example: if you erase a few lines and end up with 100 items in the list, "AA1" should be set to 99; that is 100 - 1 for the title row) . Not to worry when adding items; the code would do the change at "AA1" (see the code). -For the ListBoxes, don't forget to set the ColumnWidths (set at the ListBox's Properties) according to your Excel list (for this project, ColumnWidths: 120 pt;40 pt;200 pt;40 pt). Also, don't forget to set the ControlSource to "I10" (without quotes) at the ListBox1 properties. "I10" can be any other free cell -For the Print button at UserForm2, CurrentRegion is used. Do some reading to learn what this is and what it does (basically, it selects what's near-to the right of the cell specified; right of "O1" for this project) -The code portion "Application.WorksheetFunction" used at the Summarize button is to be able to use the Sum function (and many other functions) in the code. -The code and techniques in this programs could have been written in many other ways. The content in this video is not considered error free. -If the video is helpful ( like and subscribe ). It goes straight to the point in less than 3 minutes.