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

Answer 1 / 2
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
Answer 2 / 2
actaris51 Posted messages 106 Status Member 2
 
It works, thank you very much.
0