‘How to hide command button based on another cell - Additional buttons?’

I came across an old thread by martindwilson (full credit to him) ‘How to hide command button based on another cell?’ (http://www.excelforum.com/excel-prog...ml#post3561021).

This works faultlessly but for only 1 Button. I tried adding in the code again for a second Button but it creates a conflict. I made a slight adjustment to your original code, to show the button when the cell is populated, which works well…

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
      If Range("C27") = "" Then
      SpinButton1.Visible = False
      Else
      SpinButton1.Visible = True
      End If
      End Sub

Does anyone know a way I can:-

1. Add additional buttons which reference their own cell?

CommandButton4 – H9
CommandButton6 – I9
CommandButton2 – Q9
CommandButton3 – S9

2. And add one button which activates based on one of 3 cells?

CommandButton1 – J9 &/or V9

Any assistance would be greatly appreciated as I am a VBA novice.

http://www.ozgrid.com/forum/showthread.php?t=185711