Converting VBA GoSub to VB.NET

By Matt Woicik|2021-05-02T17:08:52-07:00January 31st, 2017|Categories: Websites|

I am converting some Visual Basic for Application (VBA) code in a Excel 97 file into a ASP.NET file using VB.NET. The code used the GoSub command which is no longer supported. So, I did some research and found out I should use a Call and Sub statements. So, I altered the code. I had some issues with the variables and found out I needed to put them outside subroutines.

Resources

https://msdn.microsoft.com/en-us/library/bkd98f37(v=vs.71).aspx
http://www.homeandlearn.co.uk/NET/nets9p2.html
http://stackoverflow.com/questions/19149978/how-to-access-variables-in-private-subs

About the Author: Matt Woicik

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.