(Simple) Showing Labels in UserForm as percentage format

[Floyds_Of_London]

I created a userform that displays certain values within row of the active cell, as a quick reference in a lofty spreadsheet. Right now it shows all values as regular numbers (shows "1" instead of "100%"), even if the referenced cell is a percentage. Code below --- i want Label9 to show up as a percentage.

Private Sub UserForm_Activate()


Label6.Caption = Range("F" & (ActiveCell.Row)).Value
Label7.Caption = Range("G" & (ActiveCell.Row)).Value
Label8.Caption = Range("H" & (ActiveCell.Row)).Value
Label9.Caption = Range("I" & (ActiveCell.Row)).Value

End Sub

 

[Marc L]

​

Your bad 'cause you use the Value property instead of the cell layout via its Text property …​

 

[Floyds_Of_London]

​

Your bad 'cause you use the Value property instead of the cell layout via its Text property …​

I'm sorry, I do not understand

 

[Marc L]

​

Which cell property do you use in your code ?​

 

[Floyds_Of_London]

​

Which cell property do you use in your code ?​

I don't even know how to answer that - I am extremely green here. Pretend i'm from a different planet

 

[Marc L]

As « solution belongs to good enough readers » so why using Value in your code instead of Text property ? …​

 

[My Aswer Is This]

I don't even know how to answer that - I am extremely green here. Pretend i'm from a differe

 

[My Aswer Is This]

I think he wants your code to look like this:
Label6.Caption = Range("F" & (ActiveCell.Row)).Text