View original (French)

VBA: Display parameter in a label

Solved
actaris51 Posted messages 106 Status Member -  
actaris51 Posted messages 106 Status Member -
Hello,

Is it possible to retrieve a parameter from our Excel workbook (for example in cell B3 of the sheet "toto") and display it in this label, so that the label reads: "The value of this indicator is: " + parameter + "%" ?

Thank you

Configuration: Windows 2000 Internet Explorer 6.0

2 answers

  1.
    redonky Posted messages 103 Status Member 23
     
    Hello,

    yes by doing

    The_parameter = Range("B3")
    UserForm_Name.Label_Name.Caption = "The value of this indicator is: " & The_parameter & "%"
    0
  2. actaris51 Posted messages 106 Status Member 2
     
    It works, thank you very much.
    0