View Full Version : how to write if a=b in VBA?
maryam
04-13-2007, 04:54 AM
in some other software I was writting if a==b , how to define this equality condition in VBA?
maryam
04-13-2007, 05:31 AM
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
04-13-2007, 05:39 AM
If CStr(Worksheets("worksheet").Cells(1, 2).Value) = Userform.Caption Then
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.