Announcement

Collapse
No announcement yet.

Match TextBox Value with Range value

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Match TextBox Value with Range value



    sheet2 range A2:A10 contains name and in
    userform TextBox1 and command Button
    i issue is when i click on command button in userform if TextBox name is match with sheet2 range A2:A10 then message box show Exits name else message box show Do not exits name
    how to done by vba in excel userform


  • #2


    try this:

    Code:
    On Error Resume Next
      If IsEmpty(Application.WorksheetFunction.Match(TextBox1, Range("a10:a13"), 0)) Then x = MsgBox("No Match") Else x = MsgBox("Match")
    On Error GoTo 0

    Comment

    Working...
    X