Is Match the correct procedure to use

[ipbr21054]

Basically on my userform I have commandbutton1 I plan to show / hide it depending on whether a value is present or not.

Let me explain.
The userform opens & the value in Textbox1 is noted. The value should be compared with Table 42. If Textbox1 value is present in Table 42 then hide commandbutton1, if the value isn’t present then show commandbutton1

Thanks.

 

[DanteAmor]

Try:

Private Sub TextBox1_Change()
  Dim f As Range
  Set f = Range("Table42").Find(TextBox1.Value, , xlValues, xlWhole, , , False)
  If Not f Is Nothing Then
    CommandButton1.Visible = True
  Else
    CommandButton1.Visible = False
  End If
End Sub

Private Sub UserForm_Activate()
  CommandButton1.Visible = False     'Change to True if you want the commandbutton to be visible when starting the userform
End Sub

 

[ipbr21054]

Thanks it worked great .

Have a nice day