Test No. What am I testing? How will I test it? If, on the custom selection, an extra has On the user form click an extra to enable 11 a quantity above 0 and is then it, and then the spinner for the quantity so deselected, will it go back to 0 for all it goes above 0, and then deselect the extra values? and check all values go to 0 (Price & Quantity). Expected Outcome of test The values of the quantity linked to the spinner and the quote value price for one will be zero when the extra is deselected, effectively it is reset. 3 PIR sensors are requested when it is selected, but when PIR sensors is deselected, the cost of that particular extra and the quantity in this particular quote go back to 0. Test No. What am I testing? How will I test it? Does the command button on the form Click close on the user form, and it should 12 work for ‘close’? close the user form and go to the worksheet format. Expected Outcome of test The user form closes, placing us with just the worksheets in front of us. Actual Outcome As expected. This is what is displayed when opened. After I click the close button in the bottom left hand corner, the form closes, as shown below. After I close the form, it took me back to the visual basic screen, as I was testing by only previewing the form using the play button in VBA. Test No. What am I testing? How will I test it? Does the command button on the form Click on archive quote and it should copy 13 work for ‘Archive Quote’? all of the data entered into the form into a separate worksheet which is where all archived data will be stored. Expected Outcome of test All current data should be archived away, but the user form should not close after it is clicked. Actual Outcome As expected. Test No. What am I testing? How will I test it? Does the command button on the form Click on the print quote button on the user 14 work for ‘Print Quote’? form and it should print the quote worksheet which contains the current data from the user form. Expected Outcome of test A copy of the quote worksheet should be printed; this should contain all of the data that is currently in the user form. Actual Outcome As expected. As you can see from the screenshot above, when I clicked on print, the macro in this button sent the message to print the quote off for the customer. Test No. What am I testing? How will I test it? On the quote, does the half not selected Open user form and spreadsheet and check 15 (custom/generic) hide when not whether the ‘quote’ worksheet selected? Expected Outcome of test The half not selected, will be hidden on the quote with zero value and therefore will not affect the overall price. Actual Outcome As expected. As you can see from the screenshot, when custom package is selected, the printable quote behind the user form looks like the above. When generic is selected, the custom details are hidden and only the generic package details are shown, as proven in the screenshot above. Test No. What am I testing? How will I test it? Are all costs shown on the quote Print a quote off, and check it has all cost 16 printed, including cost of extras, cost of details required. installation, initial system cost and overall cost? Expected Outcome of test The quote will have all costs clearly shown and a total cost (this being the total quote price). Actual Outcome As expected. In the two screenshots above, you can see the details entered into the user form on the left are clearly shown in the printable quote on the right; this quote sheet is generated via the information on the form. Test No. What am I testing? How will I test it? Does the quote for ‘generic’ include a Choose generic on the user form, and 17 concatenate formula which displays choose an option from S, M, L, or XL, what exactly is included in the pre- then print and check it details what is made package? included in the package chosen. Expected Outcome of test On the quote, the details will be shown in a sentence, which starts with ‘Your package includes’. Actual Outcome As expected. In the above, you can see I have chosen a large package from the user form, and on the quote it tells me the details of this package via using a concatenate formula. This is the concatenate formula we used (above). Test No. What am I testing? How will I test it? Does the command button for ‘Clear Click on the ‘clear form’ button on the 18 Form’ work? user form and it should reset the form which contains the data entered in. Expected Outcome of test The form will effectively be reset when this button is clicked. Actual Outcome As expected.