VBA - Userform match two columns

[Anthony86]

Hi Guys,

I'm just starting to learn VBA and I'm wondering if anyone can help me out. I'm trying to match two words in two different columns, if they match then use offset to populate some information from textboxes to the right.

Is it possible to match two?

Any help will be much appreciated

 

[cerfani]

You check equality with the = operator

If Range("A1").Value = Range("B2").Value Then
    MsgBox "They match!"
End If

 

[Anthony86]

Cerfani,

Sorry If I didn't make myself clear from my previous post.. I'm using a userform in excel and hoping to find a match from two different Textboxes in column A & B.

If TextBox1.Value = Range("A:A") Then
MsgBox "They Match."
End If

Could something like this not work??

 

[cerfani]

Well you need to check each cell's value, you can't do it all at once like that. There is a function though that will search each cell, Range.Find... https://msdn.microsoft.com/en-us/vba/excel-vba/articles/range-find-method-excel

Dim searchResult As Range
Set searchResult = Range("A:A").Find(...
If Not searchResult Is Nothing Then
    MsgBox "You found it on row " & searchResult.Row
End If

Check the page for how to use the function, use the textbox value for the search value. It will return a range object if it finds something.