I have never known how to create a "Userform" in Excel other than just taking one of the worksheets and creating a form on it using various cells and columns. Since I have found user forms in the VB coding want to understand a couple things. Viewed some videos online but none show me how to get a subtotal to display before you have "saved" the new inputs.
Essentially I have an input form that the user will key in 10 - 20 amounts. Tried adding a text box to display a subtotal and then in the "Value" field and the "ControlSource" property fields putting a formula like "=txtbox1 + txtbox2" but as you know that doesn't work. How do you get a subtotal to display somewhere on the User Form??????
Also, in the text box fields where users will key in amounts, is there a way to format the field to display as "currency"?