Formatting convention for code

[Guest]

Hi everyone,

Please can someone point me to where I can find a guide or something
similiar on formatting code. At the moment I seem to have tabs all over the
place making my code very unreadable (just like my handwriting..or so I'm
told)



Many Thanks

Jim

 

[Norman Jones]

Hi Jimbola,

At the moment I seem to have tabs all over the
place making my code very unreadable (just like my handwriting..or so I'm
told)

You might care to download Stephen Bullens Smart Indenter add-in which is
available for free download at:

http://www.oaltd.co.uk/Indenter/Default.htm

 

[Rob van Gelder]

I have key words which I indent on.

These are
Sub, Function, Property, For, Do, While, If, With, Select, Case

I think that's all of them.

 

[Rob]

Jim,

Many beginner VB books cover naming conventions and formatting. You can
also do a search on google (VBA Naming conventions; vba solid code writing).

I found this site after browsing for only a few seconds:
http://www.geekgirls.com/vba_techniques.htm I think it's what you are
looking for.

Hope this helps

Rob