{"id":13693,"date":"2017-07-09T06:28:30","date_gmt":"2017-07-09T06:28:30","guid":{"rendered":"http:\/\/learnexcelmacro.com\/wp\/?p=13693"},"modified":"2022-08-05T17:13:12","modified_gmt":"2022-08-05T17:13:12","slug":"bsn-number-validator-using-excel-vba","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/","title":{"rendered":"Validate BurgerServiceNummer (BSN) using Excel VBA"},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.16″ da_disable_devices=”off|off|off” global_colors_info=”{}” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.17.6″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” hover_enabled=”0″ global_colors_info=”{}” sticky_enabled=”0″]<\/p>\n

\n

Important Note: This post will make more sense to those who stay in the Netherlands.
\nAlso do not forget to download the BSN validator tool created at the end of the post. It is FREE to download and play around with. Thanks.<\/p>\n

But wait.. even if you do not stay in the Netherlands, you will learn some interesting Algorithms!!<\/strong><\/em><\/p>\n<\/div>\n


\nBSN is the short form of Dutch Word – BurgerServiceNummer . <\/em>In English, this is called \u00a0Citizen Service Number. This is a unique\u00a0Personal Identification Number assigned by Netherlands Govt. This was introduced\u00a0in 2007. To know more about this you can read this wiki page<\/a> or you can refer the NL government website<\/a> about it. This is a 9 digit number which should corresponds to 11-check<\/a> or in dutch Elfproef<\/a><\/em><\/p>\n

\n

What is Elfproef or 11-Check – Standard<\/h1>\n

In standard Check Digit or 11-Check, individual digits are multiplied by a weighted number and summed up together. If the total sum is divisible by 11. or in other words, if the total sum is a multiple of 11 then, the number passes the 11-Check or Elfproef.
\nWeighted Number is the position number of the digit in number from right to Left direction.<\/em><\/div>\n

Example:<\/h2>\n

Check if 614961122<\/strong> is a valid 11-check number
\nTotal sum<\/strong> = 6 * 9<\/strong> + 1*8<\/strong> + 4*7<\/strong> + 9 *6<\/strong> + 6*5<\/strong> + 1*4<\/strong> + 1*3<\/strong> + 2*2<\/strong> + 2*1 = 187<\/strong>
\nCheck if Total sum is divisible by 11 => 187 \/ 11 = 17 ( Remainder = 0)
\nThis means\u00a0614961122<\/strong>\u00a0passes the 11-check standard.
\nWhat is Elfproef or 11-Check – Specific to BSN?
\nA variant of standard Elfproef is used for BSN. There is a small change in the standard. Weighted value for the last digit from Left to Right is changed from 1 to -1<\/strong> . That’s all the deviation from the standard 11-Check.<\/p>\n

Example:<\/h2>\n

Check if 614961122<\/strong> is a valid 11-check number
\nTotal sum<\/strong> = 6 * 9<\/strong> + 1*8<\/strong> + 4*7<\/strong> + 9 *6<\/strong> + 6*5<\/strong> + 1*4<\/strong> + 1*3<\/strong> + 2*2<\/strong> + 2*(-1) = 183<\/strong>
\nCheck if Total sum is divisible by 11 => 183 \/ 11 = 17 ( Remainder = 7)
\nThis means\u00a0614961122<\/strong> is not a VALID BSN Number of Netherlands<\/span>[\/fusion_text][fusion_text][fusion_text]To do this validation easily in Excel, I created a Excel VBA function using above Algorithm, to validate if a given number is a valid BSN number of Netherlands or not.
\nNote:<\/strong> With validity, I do not mean, if this is a real existing BSN number or not, but whether that number qualifies the Elfproef<\/strong> or 11-check.<\/em> VBA Code to do 11-Check (Elfproef) for BSN<\/p>\n

\n\nFunction IsValidBSN(bsn As String) As Boolean\n\n'first check if it has 9 digit\nIf VBA.Len(bsn) = 9 Then\nDim totalSum\ntotalSum = 0\n\n' Follow standard 11-check algorithm till the\n' second last digit of the 9 digit number\nFor i = 9 To 2 Step -1\ntotalSum = totalSum + CInt(VBA.Mid(bsn, 10 - i, 1)) * i\nNext\n\n' Weighted multiplication factor for\n' the last digit is (-1)\ntotalSum = totalSum + (CInt(VBA.Mid(bsn, 10 - i, 1))) * (-1)\n\n'11-Check true if divisible by 11\nIf (totalSum Mod 11) = 0 Then IsValidBSN = True Else IsValidBSN = False\n\nElse\nIsValidBSN = False ' Not a valid BSN, if length is &amp;amp;amp;amp;lt;&amp;amp;amp;amp;gt; 9 Digits\nEnd If\nEnd Function\n\n<\/code><\/pre>\n

What is the use of this function ?<\/h3>\n

This is the most important question about any thing you do… What would you do with this? What is the use of it? So this function can be used for checking if entered BSN number is a valid BSN number or not. There are companies or organizations which uses excel as a Data form for the users to enter their details like Name, Date of Birth, Address, BSN etc. In such form, you can implement such validation to prevent from entering an Invalid BSN number.<\/p>\n

How to use this function\u00a0?<\/h3>\n

This code can be used in many different ways, depending on your requirement. You can call this function on clicking on a button to validate the entered BSN number and display the result accordingly.<\/p>\n

Another way of using this function can be — using it as a UDF (User Defined Function) or custom function. Where you can use it like a formula to check the validity of the BSN number entered by a user in a cell.<\/p>\n

\n
    \n
  1. Random BSN Generator – SoFiNummer Generator<\/a><\/li>\n
  2. Sending a HTML Email using Word Email Template and Excel<\/a><\/li>\n
  3. Sending a HTML Email using Word Email Template and Excel VBA<\/a><\/li>\n
  4. You can read more about User Defined Functions here on this page.<\/a><\/li>\n
  5. 4 Simple Steps to Create your Own Custom Formula<\/a><\/li>\n<\/ol>\n<\/div>\n

    [\/et_pb_text][et_pb_cta title=”Your FREE Workbook to Play around” button_url=”\/excel\/wp-content\/downloads\/BSN-Number-Validator.xlsm” button_text=”Download FREE Workbook” _builder_version=”4.17.6″ _module_preset=”a50a16dd-d05f-4ea2-acab-1468d2e4010e” global_colors_info=”{}”]At last, your free copy of the Excel workbook, which you can download and play around with code.<\/p>\n

    This workbook has examples of both the usage I explained above.<\/p>\n

    \"BSN

    Excel VBA code to Validate BSN<\/p><\/div>[\/et_pb_cta][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n<\/span>","protected":false},"excerpt":{"rendered":"

    Important Note: This post will make more sense to those who stay in the Netherlands. Also do not forget to download the BSN validator tool created at the end of the post. It is FREE to download and play around with. Thanks. But wait.. even if you do not stay in the Netherlands, you will […]<\/p>\n","protected":false},"author":45,"featured_media":13729,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"

    Important Note: This post will make more sense to those who stay in Netherlands.<\/p>\r\n

    But wait.. even if you do not stay in Netherlands, you will learn some interesting Algorithm!!<\/strong><\/em><\/p>\r\n<\/div>\r\n\r\nBSN is the short form of Dutch Word - BurgerServiceNummer . <\/em>In English, this is called \u00a0Citizen Service Number. This is a unique\u00a0Personal Identification Number assigned by Netherlands Govt. This was introduced\u00a0in 2007. To know more about this you can read this wiki page<\/a> or you can refer the NL government website<\/a> about it. This is a 9 digit number which should corresponds to 11-check<\/a> or in dutch Elfproef<\/a><\/em>\r\n\r\n

    \r\n

    What is Elfproef or 11-Check - Standard<\/h1>\r\nIn standard Check Digit or 11-Check, individual digits are multiplied by a weighted number and summed up together. If the total sum is divisible by 11. or in other words, if the total sum is a multiple of 11 then, the number passes the 11-Check or Elfproef.\r\nWeighted Number is the position number of the digit in number from right to Left direction.<\/em>\r\n<\/div>\r\n

    Example:<\/h2>\r\n\r\nCheck if 614961122<\/strong> is a valid 11-check number\r\nTotal sum<\/strong> = 6 * 9<\/strong> + 1*8<\/strong> + 4*7<\/strong> + 9 *6<\/strong> + 6*5<\/strong> + 1*4<\/strong> + 1*3<\/strong> + 2*2<\/strong> + 2*1 = 187<\/strong>\r\nCheck if Total sum is divisible by 11 => 187 \/ 11 = 17 ( Remainder = 0)\r\nThis means\u00a0614961122<\/strong>\u00a0passes the 11-check standard.\r\nWhat is Elfproef or 11-Check - Specific to BSN?\r\nA variant of standard Elfproef is used for BSN. There is a small change in the standard. Weighted value for the last digit from Left to Right is changed from 1 to -1<\/strong> . That's all the deviation from the standard 11-Check.\r\n

    Example:<\/h2>\r\n\r\nCheck if 614961122<\/strong> is a valid 11-check number\r\nTotal sum<\/strong> = 6 * 9<\/strong> + 1*8<\/strong> + 4*7<\/strong> + 9 *6<\/strong> + 6*5<\/strong> + 1*4<\/strong> + 1*3<\/strong> + 2*2<\/strong> + 2*(-1) = 183<\/strong>\r\nCheck if Total sum is divisible by 11 => 183 \/ 11 = 17 ( Remainder = 7)\r\nThis means\u00a0614961122<\/strong> is not a VALID BSN Number of Netherlands<\/span>[\/fusion_text][fusion_text][fusion_text]To do this validation easily in Excel, I created a Excel VBA function using above Algorithm, to validate if a given number is a valid BSN number of Netherlands or not.\r\nNote:<\/strong> With validity, I do not mean, if this is a real existing BSN number or not, but whether that number qualifies the Elfproef<\/strong> or 11-check.<\/em> VBA Code to do 11-Check (Elfproef) for BSN\r\n \r\n
    \r\n\r\nFunction IsValidBSN(bsn As String) As Boolean\r\n\r\n'first check if it has 9 digit\r\nIf VBA.Len(bsn) = 9 Then\r\nDim totalSum\r\ntotalSum = 0\r\n\r\n' Follow standard 11-check algorithm till the\r\n' second last digit of the 9 digit number\r\nFor i = 9 To 2 Step -1\r\ntotalSum = totalSum + CInt(VBA.Mid(bsn, 10 - i, 1)) * i\r\nNext\r\n\r\n' Weighted multiplication factor for\r\n' the last digit is (-1)\r\ntotalSum = totalSum + (CInt(VBA.Mid(bsn, 10 - i, 1))) * (-1)\r\n\r\n'11-Check true if divisible by 11\r\nIf (totalSum Mod 11) = 0 Then IsValidBSN = True Else IsValidBSN = False\r\n\r\nElse\r\nIsValidBSN = False ' Not a valid BSN, if length is &lt;&gt; 9 Digits\r\nEnd If\r\nEnd Function\r\n\r\n<\/code><\/pre>\r\n\r\n

    What is the use of this function ?<\/h3>\r\nThis is the most important question about any thing you do... What would you do with this? What is the use of it? So this function can be used for checking if entered BSN number is a valid BSN number or not. There are companies or organizations which uses excel as a Data form for the users to enter their details like Name, Date of Birth, Address, BSN etc. In such form, you can implement such validation to prevent from entering an Invalid BSN number.\r\n\r\n

    How to use this function\u00a0?<\/h3>\r\nThis code can be used in many different ways, depending on your requirement. You can call this function on clicking on a button to validate the entered BSN number and display the result accordingly.\r\n\r\nAnother way of using this function can be -- using it as a UDF (User Defined Function) or custom function. Where you can use it like a formula to check the validity of the BSN number entered by a user in a cell.\r\n\r\n
    \r\nYou can read more about User Defined Functions here on this page.<\/a>\r\n4 Simple Steps to Create your Own Custom Formula<\/a>\r\n<\/div>","_et_gb_content_width":"","footnotes":""},"categories":[1673,2056],"tags":[],"class_list":["post-13693","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-functions","category-udf"],"yoast_head":"\nBSN Number validator in Excel VBA - FREE Download Workbook<\/title>\n<meta name=\"description\" content=\"[FREE DOWNLOAD] Macro to validate BSN. Macro to check 11-check or Elfproef. Excel Formula to validate BSN in Excel Sheet. Validate BSN in excel\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Validate BurgerServiceNummer (BSN) using Excel VBA\" \/>\n<meta property=\"og:description\" content=\"[FREE DOWNLOAD] Macro to validate BSN. Macro to check 11-check or Elfproef. Excel Formula to validate BSN in Excel Sheet. Validate BSN in excel\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2017-07-09T06:28:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-05T17:13:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/07\/id-card.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"400\" \/>\n\t<meta property=\"og:image:height\" content=\"267\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Validate BurgerServiceNummer (BSN) using Excel VBA\",\"datePublished\":\"2017-07-09T06:28:30+00:00\",\"dateModified\":\"2022-08-05T17:13:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/\"},\"wordCount\":799,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/07\/id-card.jpg\",\"articleSection\":[\"Excel Functions\",\"User Defined Function\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/\",\"name\":\"BSN Number validator in Excel VBA - FREE Download Workbook\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/07\/id-card.jpg\",\"datePublished\":\"2017-07-09T06:28:30+00:00\",\"dateModified\":\"2022-08-05T17:13:12+00:00\",\"description\":\"[FREE DOWNLOAD] Macro to validate BSN. Macro to check 11-check or Elfproef. Excel Formula to validate BSN in Excel Sheet. Validate BSN in excel\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/07\/id-card.jpg\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/07\/id-card.jpg\",\"width\":400,\"height\":267},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"User Defined Function\",\"item\":\"https:\/\/vmlogger.com\/excel\/udf\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Validate BurgerServiceNummer (BSN) using Excel VBA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"BSN Number validator in Excel VBA - FREE Download Workbook","description":"[FREE DOWNLOAD] Macro to validate BSN. Macro to check 11-check or Elfproef. Excel Formula to validate BSN in Excel Sheet. Validate BSN in excel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/","og_locale":"en_US","og_type":"article","og_title":"Validate BurgerServiceNummer (BSN) using Excel VBA","og_description":"[FREE DOWNLOAD] Macro to validate BSN. Macro to check 11-check or Elfproef. Excel Formula to validate BSN in Excel Sheet. Validate BSN in excel","og_url":"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2017-07-09T06:28:30+00:00","article_modified_time":"2022-08-05T17:13:12+00:00","og_image":[{"width":400,"height":267,"url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/07\/id-card.jpg","type":"image\/jpeg"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Validate BurgerServiceNummer (BSN) using Excel VBA","datePublished":"2017-07-09T06:28:30+00:00","dateModified":"2022-08-05T17:13:12+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/"},"wordCount":799,"commentCount":1,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/07\/id-card.jpg","articleSection":["Excel Functions","User Defined Function"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/","url":"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/","name":"BSN Number validator in Excel VBA - FREE Download Workbook","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/07\/id-card.jpg","datePublished":"2017-07-09T06:28:30+00:00","dateModified":"2022-08-05T17:13:12+00:00","description":"[FREE DOWNLOAD] Macro to validate BSN. Macro to check 11-check or Elfproef. Excel Formula to validate BSN in Excel Sheet. Validate BSN in excel","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/07\/id-card.jpg","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2017\/07\/id-card.jpg","width":400,"height":267},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2017\/07\/bsn-number-validator-using-excel-vba\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"User Defined Function","item":"https:\/\/vmlogger.com\/excel\/udf\/"},{"@type":"ListItem","position":3,"name":"Validate BurgerServiceNummer (BSN) using Excel VBA"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/13693"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=13693"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/13693\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media\/13729"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=13693"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=13693"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=13693"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}