VBA - Quick question

[Nordicrx8]

Hey all!

I'm sure this is an easy one, but I'm not very familiar with VBA. Essentially I'm trying to hide a submit button until one of the two selections are made from a drop down in I8.

The below works for one phrase, but I can't figure out how to add another phrase to it.

I want it so if they select either of the following, the button will appear:

"I'm ready to submit! (This is your digital signature)"
---OR---
"I'm opting out of this round"

Here is the code that works for the first phrase. could someone help me with adding the code for the second?

thank you!

Private Sub Worksheet_Change(ByVal Target As Range)

With ActiveSheet
.Shapes("Button1").Visible = (.Range("I8") = "I'm ready to submit! (This is your digital signature)")

End With

End Sub

 

[Fluff]

How about

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Target.Address(0, 0) = "I8" Then
      If Target.Value = "I'm ready to submit! (This is your digital signature)" Or Target.Value = "I'm opting out of this round" Then
         Me.Shapes("Button1").Visible = True
      Else
         Me.Shapes("Button1").Visible = False
      End If
   End If
End Sub

 

[Nordicrx8]

Worked perfectly - thanks so much!!

 

[Fluff]

Glad to help & thanks for the feedback