This video demonstrates how to create a VBA userform. The data collected in the userform is passed to variables in a sub procedure. The example given is of a userform that asks for investment information: capital to invest, term and interest rate. The sub procedure that is run from the userform creates an investment projection based on this information.
------------------------