Display answer in user form based on value in a workbook

[blimey88]

I have a user form that provides the end user with a simplified display of information, I need to populate a text box with the word 'Blocked' if the value in the workbook = 0

 

[DanteAmor]

Try

Private Sub UserForm_Activate()
  If Sheets("Sheet1").Range("F1").Value = 0 Then TextBox1.Value = "Blocked"
End Sub

 

[blimey88]

Many thanks Dante this was very helpful

 

[DanteAmor]

Many thanks Dante this was very helpful

Im glad to help you, thanks for the feedback!