I found a thread that shows how to Hide/Unhide a command button based on a single cell value, which I changed to the following:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Range("B6") = "" Then
CommandButton1.Visible = False
Else
CommandButton1.Visible = True
End If
End Sub
I wanted to change this further so that two different cells have to have info before the command button appears. I tried a few different variations in the if Range part of the code but kept getting a an error.
Is it possible to have the range setup as two different cells before unhiding the command button?
Bookmarks