{"id":14379,"date":"2017-10-12T20:46:34","date_gmt":"2017-10-12T20:46:34","guid":{"rendered":"http:\/\/learnexcelmacro.com\/wp\/?p=14379"},"modified":"2017-10-12T21:23:39","modified_gmt":"2017-10-12T21:23:39","slug":"random-bsn-generator-tool","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2017\/10\/random-bsn-generator-tool\/","title":{"rendered":"Random BSN Generator – SoFiNummer Generator"},"content":{"rendered":"
Dear Friends,<\/p>\n
In one of my previous article, I explained you about Netherlands BSN Number<\/a> validation. This used to be called as SoFi nummer <\/a>(Short form of dutch word – So<\/strong>ciaalfi<\/strong>scaal nummer) as well in the Past. Here in this article, I am sharing VBA code and a FREE downloadable excel to generate random BSN numbers. In the previous article, I had shared in detail about the followings:<\/p>\n [fullwidth background_color=”#fff4f4″ background_image=”” background_parallax=”none” parallax_speed=”0.1″ enable_mobile=”no” background_repeat=”no-repeat” background_position=”left top” video_url=”” video_aspect_ratio=”16:9″ video_webm=”” video_mp4=”” video_ogv=”” video_preview_image=”” overlay_color=”” overlay_opacity=”0.5″ video_mute=”yes” video_loop=”yes” fade=”no” border_size=”1px” border_color=”#ff8e8e” border_style=”solid” padding_top=”20″ padding_bottom=”20″ padding_left=”20″ padding_right=”20″ hundred_percent=”no” equal_height_columns=”no” menu_anchor=”” class=”” id=””]<\/p>\n [\/fullwidth]<\/p>\n I would recommend you to read that article first.<\/p>\n Now since you already know enough about BSN number, here I am going to share with you a VBA code which can help you in generating a random valid BSN Number. I have also create a downloadable excel tool to generate the Random BSN number which can be downloaded from the link mentioned at the end of this article. Here is a screen shot of the tool:<\/p>\n <\/p>\n For testing any application which uses a BSN number as an input, every time you need a valida BSN number handy to use it. This simple VBA code can be used to achieve this. 1.<\/strong> For this to work you do not need to be connected to Internet. It consists of two functions. 2. Function to validate whether a 9 digit number is a valid BSN number or not?<\/p>\n
\nAt the end of this article, you will find a download link to download the tool – Random BSN Generator Tool – Excel.<\/p>\n<\/i> What is Elfproef or 11-Check \u2013 Specific to BSN<\/a><\/h3>\n
<\/i> What is BSN Number<\/a><\/h3>\n
<\/i> VBA Code to do 11-Check (Elfproef) for BSN<\/a><\/h3>\n
<\/i> A downloadable excel tool – BSN Validator – Function and UDF both<\/a><\/h3>\n
Random BSN Number Generator in Excel using VBA<\/h1>\n
What is the Use of this Code \/ Tool?<\/h1>\n
\nYou can ofcourse get it generated from Internet. There are websites which generates a random BSN number every time you press a button.
\nThis excel tool, also does the same thing.<\/p>\nAdvantages<\/h2>\n
\n2.<\/strong> If you are capturing your Test data or test cases in Excel, you don’t have to generate it from some website and put it in your excel sheet.<\/p>\nLogic used behind generating this Random BSN number<\/h1>\n
\n1. Function to generate a Random 9 digit Number between 100000000(lowest 9 digit number) and 999999999 (highest 9 digit number).<\/p>\n