Funtion Proper Grammar for Programming

Good day,

Still being exposed to new things in VBA, my code was getting a tad long and I wanted to divide into smaller versions of sub code.

still experimenting with byval and byref, I understand the concept of it however i need practice,

by val passes just the value, by ref changes the value in the function and when it returns to the main (I think that's right ...)

However,

I want to ask how the code should look? (Am I doing this right?)

In my main I have to declare all general variables, and in the functions I can declare local variables if they only pertain to it and never have to use them again?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

what if I want to add coments like i did on my main for each variable? would the following be acceptable?

Please Login or Register  to view this content.