how to write if a=b in VBA?

[maryam]

in some other software I was writting if a==b , how to define this equality condition in VBA?

[maryam]

in some other software I was writting if a==b , how to define this equality condition in VBA?
I need comparing operating for the followings, I used Is but it gives mismatch:
result = CStr(Worksheets("worksheet").Cells(1, 2).Value) Is Userform.Caption

Userform's caption is just a name and the same string is in the sheet's cell.

[Bob Phillips]

If CStr(Worksheets("worksheet").Cells(1, 2).Value) = Userform.Caption Then