Caption made up by Concatenated text

[samz93]

Hi!
I am making a user form for a loan ammortisation table and need to include a label control with a caption made up by the concatenated text of:
“Scheduled (” & paym_freq & “) Payments: £” & R. [Where the payment frequency can be monthly, quarterly, or yearly and the first installment amount is R)
for example, resulting: Scheduled (monthly) Payments: £192.59, where paym_freq and R are the main (i.e. VBA variables) repayment frequency and repayment amount (rounded down to 2 decimal places), respectively. So at the start up of the userform, the caption should be based on the values already present on the spreadsheet. However, during run time of the User Form, the variables entered any changes of the controls defined above should trigger the recalculation of the R value and, in turn, the re-evaluation of the caption text of this label.
Would really appreciate some help!
Thanks in advance

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic