Thread: Compare Strings
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Compare Strings

Hi,

You can try this:

Me.TextBox1 = Me.TextBox2 And Me.TextBox1 = Me.TextBox3


If this helps, please check the Yes button

--
Thanks,
Shane Devenshire


"dksaluki" wrote:

Is there an easy way (using VBA) to compare the values of 3 text
boxes? I want to make sure that the values of all 3 text boxes are
NOT the same. I tried StrComp, but that only compares 2 string. I
assumed there would be an easy way without having nested if's....


Thanks,
DK