Jump to content

Talk:Visual Basic/Coding Standards

Page contents not supported in other languages.
Add topic
From Wikibooks, open books for an open world
Latest comment: 9 years ago by JackPotte in topic Line Numbers in VBA

24.47.80.195

[edit source]

Please log in so we can collaborate on changes. It's good to see someone taking an interest. --kwhitefoot 06:23, 8 May 2006 (UTC)Reply

Procedure Calls

[edit source]

I was wondering why "This standard deprecates the use of the Call keyword."? What then should be the best approach for multiple arguments procedures? I think "Call MyFunction(arg1, arg2)" looks more like a function call than "MyFunction arg1, arg2", due to the parenthesizes.

Maybe because the call result must be stored in a variable to return a proper user output. JackPotte (discusscontribs) 18:13, 22 October 2016 (UTC)Reply

Line Numbers in VBA

[edit source]

Any thoughts about the conventional layout for line numbers. I am trying to add them to an indenting procedure but realize that I am not sure about the standard.

For example, should numbers fall below sub and function, or stand off to the left margin with sub and function in "next column", so to speak?

Thanks in advance for any input. Armchair (discusscontribs) 10:48, 22 October 2016 (UTC)Reply

As it's impossible to display the VBA line numbers in Excel, plenty of alternatives had been proposed. But I've never read any convention. JackPotte (discusscontribs) 18:13, 22 October 2016 (UTC)Reply