> post the code and ask for coding style suggestions
Actually a great idea!!!
Everyone has different styles so this would be a terrific "excersize" for the group to chip in!
Example.... I use a naming convention for entities of my own which is...
Sub procedures always preceeded bur lowercase "sub" and starting with a capital after that.
ex... subInitialize()
Function procedures likewise but with "fnc" instead of sub.
I include a type and a scope in variable prefixes....
Dim lnglN as Long... lng = long l = local.
The single letter l can be p=parameter m=module level g=global
I also format my code in a particular manner. If people are interested I'd be happy to share.
Any other offers?? Anyone use a personal set of "rules"? What are they?
I'd also be very interested to know how adding comments solved your probbie Duncan?
Lisa
-----Original Message-----
From: 'David Smart' smartware.consulting@gmail.com [ExcelVBA] <ExcelVBA@yahoogroups.com>
To: ExcelVBA <ExcelVBA@yahoogroups.com>
Sent: Sat, Apr 11, 2015 1:37 am
Subject: Re: [ExcelVBA] Auto-populate a cell based on several other values
Glad you got it working.
If you'd like "improvement" commentary, by all means post the code and ask for coding style suggestions.
Regards, Dave S
----- Original Message -----
Sent: Friday, April 10, 2015 10:54 PM
Subject: Re: [ExcelVBA] Auto-populate a cell based on several other values
Guys, many thanks for the help, tips & pointers.
After commenting the code, it became clear what it should have been. I now have it populating as it should!
Still looking at it to see if there's anything that can be improved.
Once again, cheers.
Duncan
On 8 Apr 2015 19:49, "Green
1z@compuserve.com [ExcelVBA]" <
ExcelVBA@yahoogroups.com> wrote:
No sorrys ness Duncan... It *seems* like an interesting problem.
And don't forget that it's poss to upload a file for the group!
Lisa
No virus found in this message.
Checked by AVG -
www.avg.com Version: 2015.0.5863 / Virus Database: 4328/9506 - Release Date: 04/10/15
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here:
http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA ----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com ----------------------------------
Tidak ada komentar:
Posting Komentar