Consulting

Results 1 to 3 of 3

Thread: How to show percentages from multiple cells in the caption for one.. userform button

  1. #1

    How to show percentages from multiple cells in the caption for one.. userform button

    Hi,

    I've created a very simple userform to monitor certain stats for a call centre. The mock example I've attached will explain better, but essentially I want the percentages from multiple cells to show as the caption for the command button. Its very simple for numbers, but I cant make it work with the percentages. I've done similar tasks with single cell percentages, but it all goes belly up when I try to be "Clever".
    Attached Files Attached Files

  2. #2
    Knowledge Base Approver VBAX Wizard
    Joined
    Apr 2012
    Posts
    5,645
    Private Sub UserForm_Initialize()
        CmdVbax.Caption = FormatPercent(ThisWorkbook.Sheets("sheet1").Range("J8").Value) & vbTab & FormatPercent(ThisWorkbook.Sheets("sheet1").Range("L8").Value)
    End Sub

  3. #3
    Snb, I salute you!. Thank you very much.

Posting Permissions

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