VB Userform help

[hail11]

i have a label 5 in my VBA i would like to be able to swich what it says depending on what the linked page has picked
this is what i need

If sheet 9 range a132 = "Y" then sheet 9 range a133
If sheet 9 range a132 = "N" then sheet 9 range a134
If sheet 9 range a132 = "" then sheet 9 range a133



Please help

 

[Ron Morris]

Hi,

Add the following code to the event that drives the label caption change:

If (Sheets("sheet9").Range("A132").Value = "Y" or _
     Sheets("sheet9").Range("A132").Value = "") then
     Label5.Caption = Sheets("sheet9").Range("A133").Value
Elseif Sheets("sheet9").Range("A132").Value = "N" then
     Label5.Caption = Sheets("sheet9").Range("A134").Value
End If

Ron

EDIT: fixed Code tags - Moderator

 

[hail11]

how can i make if = Y or "" make the font black
but if it is N then red font?

 

[hail11]

i have
Private Sub Label5_Click()
If (Sheets("sheet8").Range("C179").Value = "Y" Or _
Sheets("sheet8").Range("C179").Value = "") Then
Label5.Caption = Sheets("sheet8").Range("B182").Value
ElseIf Sheets("sheet8").Range("C179").Value = "N" Then
Label5.Caption = Sheets("sheet8").Range("B183").Value
End If

End Sub

It brings up a debug error and i just want to look at it not have to click on it

 

[hail11]

ok i have this
Private Sub userform_Initialize()
Me.Label5.Caption = Worksheets("Sheet8").Range("b184").Value
End Sub

this is what i needed