User talk:Goldbishop

Welcome
Hi, welcome to Microsoft Wiki! Thanks for your edit to the Microsoft Access page.

Please leave a message on my talk page if I can help with anything! -- Gboyers (Talk) 17:42, July 26, 2012

Re: VBA Coding
In terms of the code itself the way you've been doing it seems fine. Use the code template, indent things like loops/ifs, use very helpful variable/function names, and use plenty of comments.

I would ensure that you give a thorough, accurate and helpful description, not just saying "this is how to use [FunctionName]". This is because users might not be searching for the right function name, they want to know how to achieve a result, and it also helps other editors understand the page and be able to contribute to it.

Likewise with comments, I would keep them really simple and basic. If you're giving examples of basic code (like .calculate) then there's no point explaining return variables and public functions, just say things like "this line calculates all cells in the given range". Anything more complex will likely be confusing for basic users.

I would also suggest you separate the basic code from long-winded examples. Here I have shown the specific code needed (which most people will want), then later have full example of the functions in case someone wanted that wholesale.

I might also suggest we rename "snippets" so something a bit more descriptive, like "VBA Examples". Also, I'm not sure whether sorting by application/worksheet is the most obvious way, probably would be easier to sort by what they want to achieve? For example "Interface and Settings", "Finding Data", "Altering Data" etc. Some snippets may have to appear under multiple listings, but that's fine.

I hope those suggestions are useful, but it all seems good to me! Gboyers talk 19:51, January 3, 2013 (UTC)