{"id":8938,"date":"2023-03-10T02:28:15","date_gmt":"2023-03-10T02:28:15","guid":{"rendered":"https:\/\/www.excel-learn.com\/?p=8938"},"modified":"2023-10-27T19:59:13","modified_gmt":"2023-10-27T19:59:13","slug":"vba-equal-not-equal-operators","status":"publish","type":"post","link":"https:\/\/www.excel-learn.com\/vba-equal-not-equal-operators\/","title":{"rendered":"6 Examples to Understand VBA Equal and Not Equal to Operators"},"content":{"rendered":"<div class=\"has-left-border-and-background-color\">\n<h3><strong>What is equal to and not equal to operators in VBA?<\/strong><\/h3>\n<ul>\n<li>Equal to and Not Equal to are comparison operators in VBA.<\/li>\n<li>These are used to check or compare values.<\/li>\n<li>Let us take a look at examples one by one.<\/li>\n<\/ul>\n<\/div>\n<h3><strong>What is Not Equal to Operator in VBA?<\/strong><\/h3>\n<p>In VBA, Not Equal to operator is used as:<\/p>\n<blockquote><p><strong>&lt;&gt;\u00a0<\/strong><\/p><\/blockquote>\n<p>For example:<\/p>\n<blockquote><p><strong>a &lt;&gt; b<\/strong><\/p><\/blockquote>\n<p>If a is not equal to b then it returns <strong>True<\/strong> otherwise <strong>False<\/strong>. Let us see this in examples.<\/p>\n<h3><strong>A simple example of checking two variables by not equal to <\/strong><\/h3>\n<ul>\n<li>We declared two <a href=\"https:\/\/www.excel-learn.com\/vba-integer-vs-long\/\">integer<\/a> type variable<\/li>\n<li>Assigned values and checked in the If statement<\/li>\n<\/ul>\n<p><strong>Code:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Sub not_equal_ex()\r\nDim a As Integer\r\n\r\nDim b As Integer\r\n\r\na = 10\r\n\r\nb = 20\r\n\r\nIf a &lt;&gt; b Then\r\n\r\n\u00a0\u00a0\u00a0 MsgBox \"a and b are not equal!\"\r\n\r\nElse\r\n\r\n\u00a0\u00a0\u00a0 MsgBox \"a and b are equal!\"\r\n\r\nEnd If\r\n\r\nEnd Sub<\/pre>\n<p><strong>Result:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-8944\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/61_1-VBA-not-equal-to.png\" alt=\"VBA-not-equal-to\" width=\"200\" height=\"172\" \/><\/p>\n<p>As a and b are not equal, it returned True, which is why the message box inside <strong>If statement<\/strong> is displayed.<\/p>\n<p>If both values are equal then the <strong>Else<\/strong> statement should have executed as shown below:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Sub not_equal_ex()\r\n\r\nDim a As Integer\r\nDim b As Integer\r\n\r\n\r\na = 10\r\n\r\nb = 10\r\n\r\nIf a &lt;&gt; b Then\r\n\r\n\u00a0\u00a0\u00a0 MsgBox \"a and b are not equal!\"\r\n\r\nElse\r\n\r\n\u00a0\u00a0\u00a0 MsgBox \"a and b are equal!\"\r\n\r\nEnd If\r\n\r\nEnd Sub<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-8943\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/61_2-VBA-not-equal-to-False.png\" alt=\"VBA-not-equal-to-False\" width=\"203\" height=\"157\" \/><\/p>\n<p>As the condition is <strong>False<\/strong> i.e. a is equal to b (while we were testing if a is not equal to b), so Else statement is executed.<\/p>\n<h3><strong>What is equal to operator<\/strong><\/h3>\n<p>The \u201cEqual to\u201d is also a comparison operator used by this sign \u201c=\u201d. For example:<\/p>\n<blockquote><p>a = b<\/p><\/blockquote>\n<p>It returns True if both values are equal, otherwise, False. So, it\u2019s opposite to the \u201c&lt;&gt;\u201d operator.<\/p>\n<h3><strong>An example of Equal to (=) operator<\/strong><\/h3>\n<p>Again we have two variables and test their values for equality.<\/p>\n<p>If both are equal then it should return True and If statement should execute.<\/p>\n<p>If False, Else statement should execute.<\/p>\n<p><strong>Code:<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Sub equal_ex()\r\n\r\nDim a As Integer\r\n\r\nDim b As Integer\r\n\r\na = 5\r\n\r\nb = 5\r\n\r\n'Checking if both variables are equal\r\n\r\nIf a = b Then\r\n\r\n\u00a0\u00a0\u00a0 MsgBox \"a and b are equal!\"\r\n\r\nElse\r\n\r\n\u00a0\u00a0\u00a0 MsgBox \"a and b are not equal!\"\r\n\r\nEnd If\r\n\r\nEnd Sub<\/pre>\n<p><strong>Result:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-8942\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/61_3-VBA-equal-to-True.png\" alt=\"VBA-equal-to-True\" width=\"217\" height=\"173\" \/><\/p>\n<p>As a and b are equal, th If returned <strong>True<\/strong> and the statement inside executed.<\/p>\n<p>Now, as we assign different values:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Sub equal_ex()\r\n\r\nDim a As Integer\r\n\r\nDim b As Integer\r\n\r\na = 50\r\n\r\nb = 100\r\n\r\n\r\n'Checking if both variables are equal\r\n\r\nIf a = b Then\r\n\r\n\u00a0\u00a0\u00a0 MsgBox \"a and b are equal!\"\r\n\r\nElse\r\n\r\n\u00a0\u00a0\u00a0 MsgBox \"a and b are not equal!\"\r\n\r\nEnd If\r\n\r\nEnd Sub<\/pre>\n<p><strong>Result:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-8941\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/61_4-VBA-equal-to-False.png\" alt=\"VBA-equal-to-False\" width=\"212\" height=\"168\" \/><\/p>\n<h3><strong>An example of not equal with Excel sheet cells<\/strong><\/h3>\n<p>In this example, we will check the equality of cells text.<\/p>\n<p>If <strong>A2 cell value is not equal to B2 <\/strong>then set the Interior\/background color of C2 to red, otherwise, green.<\/p>\n<p>See the code and sheet with the result:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Sub equality_ex()\r\n\r\nIf Range(\"A1\") &lt;&gt; Range(\"B1\") Then\r\n\r\n\u00a0\u00a0 Range(\"C1\").Interior.Color = vbRed\r\n\r\nElse\r\n\r\n\u00a0\u00a0 Range(\"C1\").Interior.Color = vbGreen\r\n\r\nEnd If\r\n\r\nEnd Sub<\/pre>\n<p><strong>Result:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-8940\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/61_5-VBA-not-equal-to-cell.png\" alt=\"VBA-not-equal-to-cell\" width=\"362\" height=\"136\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/61_5-VBA-not-equal-to-cell.png 362w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/61_5-VBA-not-equal-to-cell-300x113.png 300w\" sizes=\"(max-width: 362px) 100vw, 362px\" \/><\/p>\n<p>As A2 cell is not equal to B2 so the color is set as Red.<\/p>\n<h3><strong>Checking Range values with Equal to operator<\/strong><\/h3>\n<p>For this example, we compare the values of a <a href=\"https:\/\/www.excel-learn.com\/excel-vba-range\/\">Range<\/a> of cells by using the <strong>equal to<\/strong> operator.<\/p>\n<ul>\n<li>For that, we created a range of A to A10 cells.<\/li>\n<li>In <a href=\"https:\/\/www.excel-learn.com\/vba-for-each-loop\/\">For..Each loop<\/a>, we iterated through each cell of the range.<\/li>\n<li>In each iteration, the value of <strong>A(x)<\/strong> cell is compared to the <strong>B(x)<\/strong> cell with <strong>\u201c=\u201d<\/strong> operator.<\/li>\n<li>If the value matches (return result True), we will fill the respective C(x) color to Red and its <a href=\"https:\/\/www.excel-learn.com\/border-color-of-excel-vba\/\">border color<\/a> to White.<\/li>\n<li>If False (does not match), we will change the interior\/fill color to Yellow with Cyan border.<\/li>\n<\/ul>\n<p>Have a look:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"visualbasic\">Sub equality_ex()\r\n\r\nDim rng As Range\r\n\r\nDim x\r\n\r\nSet rng = Range(\"A1:A10\")\r\n\r\nx = 1\r\n\r\nFor Each Cell In rng\r\n\r\n\u00a0\u00a0\u00a0\r\n\r\n\u00a0\u00a0\u00a0 If Cell &lt;&gt; Range(\"B\" &amp; x) Then\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Range(\"C\" &amp; x).Interior.Color = vbRed\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Range(\"C\" &amp; x).Borders.Color = vbWhite\r\n\r\n\u00a0\u00a0\u00a0 Else\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Range(\"C\" &amp; x).Interior.Color = vbYellow\r\n\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Range(\"C\" &amp; x).Borders.Color = vbCyan\r\n\r\n\u00a0\u00a0\u00a0 End If\r\n\r\nx = x + 1\r\n\r\nNext\r\n\r\nEnd Sub<\/pre>\n<p><strong>Result:<\/strong><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-full wp-image-8939\" src=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/61_6-VBA-equal-to-cells-mul.png\" alt=\"VBA-equal-to-cells-mul\" width=\"395\" height=\"344\" srcset=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/61_6-VBA-equal-to-cells-mul.png 395w, https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/61_6-VBA-equal-to-cells-mul-300x261.png 300w\" sizes=\"(max-width: 395px) 100vw, 395px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Equal to and Not Equal to are comparison operators in VBA. Used to check or compare values, let us take a look with examples one by one.<\/p>\n","protected":false},"author":1,"featured_media":8941,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[147],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v14.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>6 Examples to Understand VBA Equal and Not Equal to Operators<\/title>\n<meta name=\"description\" content=\"Equal to and Not Equal to are comparison operators in VBA.Used to check or compare values, let us take a look with examples one by one.\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excel-learn.com\/vba-equal-not-equal-operators\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"6 Examples to Understand VBA Equal and Not Equal to Operators\" \/>\n<meta property=\"og:description\" content=\"Equal to and Not Equal to are comparison operators in VBA.Used to check or compare values, let us take a look with examples one by one.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excel-learn.com\/vba-equal-not-equal-operators\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-10T02:28:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-27T19:59:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/61_4-VBA-equal-to-False.png\" \/>\n\t<meta property=\"og:image:width\" content=\"212\" \/>\n\t<meta property=\"og:image:height\" content=\"168\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excel-learn.com\/#website\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"name\":\"Excel Tutorials\",\"description\":\"Tips, Solutions, Tricks\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.excel-learn.com\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/vba-equal-not-equal-operators\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/61_4-VBA-equal-to-False.png\",\"width\":212,\"height\":168,\"caption\":\"VBA-equal-to-False\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excel-learn.com\/vba-equal-not-equal-operators\/#webpage\",\"url\":\"https:\/\/www.excel-learn.com\/vba-equal-not-equal-operators\/\",\"name\":\"6 Examples to Understand VBA Equal and Not Equal to Operators\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/vba-equal-not-equal-operators\/#primaryimage\"},\"datePublished\":\"2023-03-10T02:28:15+00:00\",\"dateModified\":\"2023-10-27T19:59:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\"},\"description\":\"Equal to and Not Equal to are comparison operators in VBA.Used to check or compare values, let us take a look with examples one by one.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excel-learn.com\/vba-equal-not-equal-operators\/\"]}]},{\"@type\":[\"Person\"],\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\",\"name\":\"excelmaster\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"caption\":\"excelmaster\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8938"}],"collection":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/comments?post=8938"}],"version-history":[{"count":5,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8938\/revisions"}],"predecessor-version":[{"id":9683,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8938\/revisions\/9683"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media\/8941"}],"wp:attachment":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media?parent=8938"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/categories?post=8938"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/tags?post=8938"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}