{"id":759,"date":"2017-01-31T20:00:00","date_gmt":"2017-02-01T04:00:00","guid":{"rendered":"https:\/\/ml2solutions.com\/?p=759"},"modified":"2021-05-02T17:08:52","modified_gmt":"2021-05-03T00:08:52","slug":"converting-vba-gosub-to-vb-net","status":"publish","type":"post","link":"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/","title":{"rendered":"Converting VBA GoSub to VB.NET"},"content":{"rendered":"<p>I am converting some Visual Basic for Application (VBA) code in a Excel 97 file into a ASP.NET file using VB.NET.&nbsp; The code used the GoSub command which is no longer supported.&nbsp; So, I did some research and found out I should use a Call and Sub statements.&nbsp; So, I altered the code.&nbsp; I had some issues with the variables and found out I needed to put them outside subroutines.<\/p>\n<p>&nbsp;<\/p>\n<p>Resources<\/p>\n<ul>\n<li><a title=\"https:\/\/msdn.microsoft.com\/en-us\/library\/bkd98f37(v=vs.71).aspx\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/bkd98f37(v=vs.71).aspx\">https:\/\/msdn.microsoft.com\/en-us\/library\/bkd98f37(v=vs.71).aspx<\/a><\/li>\n<li><a title=\"http:\/\/www.homeandlearn.co.uk\/NET\/nets9p2.html\" href=\"http:\/\/www.homeandlearn.co.uk\/NET\/nets9p2.html\">http:\/\/www.homeandlearn.co.uk\/NET\/nets9p2.html<\/a><\/li>\n<li><a title=\"http:\/\/stackoverflow.com\/questions\/19149978\/how-to-access-variables-in-private-subs\" href=\"http:\/\/stackoverflow.com\/questions\/19149978\/how-to-access-variables-in-private-subs\">http:\/\/stackoverflow.com\/questions\/19149978\/how-to-access-variables-in-private-subs<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>I am converting some Visual Basic for Application (VBA) code in a Excel 97 file into a ASP.NET file using VB.NET.&nbsp; The code used the GoSub command which is no [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Converting VBA GoSub to VB.NET - ML2 Solutions<\/title>\n<meta name=\"description\" content=\"Converting VBA GoSub to VB.NET I am converting some Visual Basic for Application (VBA) code in a Excel 97 file into a ASP.NET file using VB.NET.&nbsp; The code used the GoSub command\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Converting VBA GoSub to VB.NET - ML2 Solutions\" \/>\n<meta property=\"og:description\" content=\"Converting VBA GoSub to VB.NET I am converting some Visual Basic for Application (VBA) code in a Excel 97 file into a ASP.NET file using VB.NET.&nbsp; The code used the GoSub command\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/\" \/>\n<meta property=\"og:site_name\" content=\"ML2 Solutions\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ml2solutions\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/ml2solutions\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-01T04:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-03T00:08:52+00:00\" \/>\n<meta name=\"author\" content=\"Matt Woicik\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ml2solutions\" \/>\n<meta name=\"twitter:site\" content=\"@ml2solutions\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Matt Woicik\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/\"},\"author\":{\"name\":\"Matt Woicik\",\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/person\/19d4de8c6be3e95b8d97ac99910766bd\"},\"headline\":\"Converting VBA GoSub to VB.NET\",\"datePublished\":\"2017-02-01T04:00:00+00:00\",\"dateModified\":\"2021-05-03T00:08:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/\"},\"wordCount\":108,\"publisher\":{\"@id\":\"https:\/\/ml2solutions.com\/#organization\"},\"articleSection\":[\"Websites\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/\",\"url\":\"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/\",\"name\":\"Converting VBA GoSub to VB.NET - ML2 Solutions\",\"isPartOf\":{\"@id\":\"https:\/\/ml2solutions.com\/#website\"},\"datePublished\":\"2017-02-01T04:00:00+00:00\",\"dateModified\":\"2021-05-03T00:08:52+00:00\",\"description\":\"Converting VBA GoSub to VB.NET I am converting some Visual Basic for Application (VBA) code in a Excel 97 file into a ASP.NET file using VB.NET.&nbsp; The code used the GoSub command\",\"breadcrumb\":{\"@id\":\"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ml2solutions.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Websites\",\"item\":\"https:\/\/ml2solutions.com\/category\/websites\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Converting VBA GoSub to VB.NET\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ml2solutions.com\/#website\",\"url\":\"https:\/\/ml2solutions.com\/\",\"name\":\"ML2 Solutions\",\"description\":\"Helping you get more leads and make more sales\",\"publisher\":{\"@id\":\"https:\/\/ml2solutions.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ml2solutions.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/ml2solutions.com\/#organization\",\"name\":\"ML2 Solutions\",\"url\":\"https:\/\/ml2solutions.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/ml2solutions.com\/wp-content\/uploads\/2016\/04\/ML2logo.png\",\"contentUrl\":\"https:\/\/ml2solutions.com\/wp-content\/uploads\/2016\/04\/ML2logo.png\",\"width\":303,\"height\":54,\"caption\":\"ML2 Solutions\"},\"image\":{\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ml2solutions\",\"https:\/\/x.com\/ml2solutions\",\"https:\/\/www.instagram.com\/ml2solutions\/\",\"https:\/\/www.pinterest.com\/ml2solutions\/\",\"https:\/\/www.youtube.com\/channel\/UCtOfam7a6aMf3Xtf6hBuJdA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/person\/19d4de8c6be3e95b8d97ac99910766bd\",\"name\":\"Matt Woicik\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/ml2solutions.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/92207c6315825666c3cc9632c4b40d7c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/92207c6315825666c3cc9632c4b40d7c?s=96&d=mm&r=g\",\"caption\":\"Matt Woicik\"},\"description\":\"Matt is a digital marketing strategist and the owner of ML2 Solutions, a digital marketing agency. He helps businesses increase awareness and get more leads using digital marketing. New marketing methods are confusing, always changing and difficult to figure out. Matt helps to explain things and provide solutions with clear results.\",\"sameAs\":[\"https:\/\/ml2solutions.com\",\"https:\/\/www.facebook.com\/ml2solutions\",\"https:\/\/www.instagram.com\/ml2solutions\/\",\"https:\/\/www.linkedin.com\/company\/ml2solutions\/\",\"https:\/\/www.pinterest.com\/ml2solutions\/\",\"https:\/\/x.com\/ml2solutions\",\"https:\/\/www.youtube.com\/channel\/UCtOfam7a6aMf3Xtf6hBuJdA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Converting VBA GoSub to VB.NET - ML2 Solutions","description":"Converting VBA GoSub to VB.NET I am converting some Visual Basic for Application (VBA) code in a Excel 97 file into a ASP.NET file using VB.NET.&nbsp; The code used the GoSub command","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:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/","og_locale":"en_US","og_type":"article","og_title":"Converting VBA GoSub to VB.NET - ML2 Solutions","og_description":"Converting VBA GoSub to VB.NET I am converting some Visual Basic for Application (VBA) code in a Excel 97 file into a ASP.NET file using VB.NET.&nbsp; The code used the GoSub command","og_url":"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/","og_site_name":"ML2 Solutions","article_publisher":"https:\/\/www.facebook.com\/ml2solutions","article_author":"https:\/\/www.facebook.com\/ml2solutions","article_published_time":"2017-02-01T04:00:00+00:00","article_modified_time":"2021-05-03T00:08:52+00:00","author":"Matt Woicik","twitter_card":"summary_large_image","twitter_creator":"@ml2solutions","twitter_site":"@ml2solutions","twitter_misc":{"Written by":"Matt Woicik","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/#article","isPartOf":{"@id":"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/"},"author":{"name":"Matt Woicik","@id":"https:\/\/ml2solutions.com\/#\/schema\/person\/19d4de8c6be3e95b8d97ac99910766bd"},"headline":"Converting VBA GoSub to VB.NET","datePublished":"2017-02-01T04:00:00+00:00","dateModified":"2021-05-03T00:08:52+00:00","mainEntityOfPage":{"@id":"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/"},"wordCount":108,"publisher":{"@id":"https:\/\/ml2solutions.com\/#organization"},"articleSection":["Websites"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/","url":"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/","name":"Converting VBA GoSub to VB.NET - ML2 Solutions","isPartOf":{"@id":"https:\/\/ml2solutions.com\/#website"},"datePublished":"2017-02-01T04:00:00+00:00","dateModified":"2021-05-03T00:08:52+00:00","description":"Converting VBA GoSub to VB.NET I am converting some Visual Basic for Application (VBA) code in a Excel 97 file into a ASP.NET file using VB.NET.&nbsp; The code used the GoSub command","breadcrumb":{"@id":"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ml2solutions.com\/websites\/converting-vba-gosub-to-vb-net\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ml2solutions.com\/"},{"@type":"ListItem","position":2,"name":"Websites","item":"https:\/\/ml2solutions.com\/category\/websites\/"},{"@type":"ListItem","position":3,"name":"Converting VBA GoSub to VB.NET"}]},{"@type":"WebSite","@id":"https:\/\/ml2solutions.com\/#website","url":"https:\/\/ml2solutions.com\/","name":"ML2 Solutions","description":"Helping you get more leads and make more sales","publisher":{"@id":"https:\/\/ml2solutions.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ml2solutions.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ml2solutions.com\/#organization","name":"ML2 Solutions","url":"https:\/\/ml2solutions.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ml2solutions.com\/#\/schema\/logo\/image\/","url":"https:\/\/ml2solutions.com\/wp-content\/uploads\/2016\/04\/ML2logo.png","contentUrl":"https:\/\/ml2solutions.com\/wp-content\/uploads\/2016\/04\/ML2logo.png","width":303,"height":54,"caption":"ML2 Solutions"},"image":{"@id":"https:\/\/ml2solutions.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ml2solutions","https:\/\/x.com\/ml2solutions","https:\/\/www.instagram.com\/ml2solutions\/","https:\/\/www.pinterest.com\/ml2solutions\/","https:\/\/www.youtube.com\/channel\/UCtOfam7a6aMf3Xtf6hBuJdA"]},{"@type":"Person","@id":"https:\/\/ml2solutions.com\/#\/schema\/person\/19d4de8c6be3e95b8d97ac99910766bd","name":"Matt Woicik","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ml2solutions.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/92207c6315825666c3cc9632c4b40d7c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/92207c6315825666c3cc9632c4b40d7c?s=96&d=mm&r=g","caption":"Matt Woicik"},"description":"Matt is a digital marketing strategist and the owner of ML2 Solutions, a digital marketing agency. He helps businesses increase awareness and get more leads using digital marketing. New marketing methods are confusing, always changing and difficult to figure out. Matt helps to explain things and provide solutions with clear results.","sameAs":["https:\/\/ml2solutions.com","https:\/\/www.facebook.com\/ml2solutions","https:\/\/www.instagram.com\/ml2solutions\/","https:\/\/www.linkedin.com\/company\/ml2solutions\/","https:\/\/www.pinterest.com\/ml2solutions\/","https:\/\/x.com\/ml2solutions","https:\/\/www.youtube.com\/channel\/UCtOfam7a6aMf3Xtf6hBuJdA"]}]}},"_links":{"self":[{"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/posts\/759"}],"collection":[{"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/comments?post=759"}],"version-history":[{"count":0,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/posts\/759\/revisions"}],"wp:attachment":[{"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/media?parent=759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/categories?post=759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ml2solutions.com\/wp-json\/wp\/v2\/tags?post=759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}