I am trying to write a code that allows a command button to be hidden on spreadsheet till a value of cell is displayed.
here is an example to the code:
Private Sub UserForm_Activate()
Sheets("Sheet1").Select
If Range("$A$1").Value = 0 Then
Forms.CommandButton1.Visible = True
Else
Forms.CommandButton1.Visible = False
End If
End Sub
The button still remains visable regardless of cell value that is am using as a reference "A1". As a side note, I am also looking at a way to add additional command buttons that will follow the same idea just different conditions. Any help would be appreciated. Thankyou in advance
Bookmarks