+ Reply to Thread
Results 1 to 2 of 2

Caption made up by Concatenated text

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Exclamation Caption made up by Concatenated text

    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

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    MS-Off Ver
    MS 365

    Re: Caption made up by Concatenated text

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1