Excel VBA Naming Conventions… (2000 SR-1)

Topic

New Reply

Does anyone have a list (or link to a list) of the proper standard naming conventions for Excel VBA programming? TIA

Reply | Quote

Replies

Here’s the Reddick conventions.

Reply | Quote

Thanks John…

I appreciate that, but that list I know… I’m looking for generally followed naming conventions specifically for Excel Objects… such as prefixes to use when declaring Excel Objects like worksheets and ranges, etc…… For example “Dim someName as Workbook” … Should that object variable name be given a certain prefix? ….and if so, is there a list of such prefixes?

Reply | Quote

I don’t have it with me right now, but I think that John Walkenbach does in his book MS Excel Power Programming with VBA. I can check tomorrow.

Reply | Quote

Thanks!… I can wait… (I’ve been wondering this for agessssss…)

Reply | Quote

He suggests prefixing a lower case:
b for Boolean
i for integer
l for Long
s for Single
d for Double
c for Currency
dt for Date/Time
str for String
obj for Object
v for Variant
u for User-defined

His XL2000 book does not really list anything for the XL objects (as was your original question). He is also not consistent in his use of the conventions. He suggests declaring the variables, but frequently does not do this in his code.

Steve

Reply | Quote

Hmmm… Well thanks anyway Steve…

I personally use…
bln for Boolean
int for Integer
lng for Long
sng for Single
dbl for Double
etc…
I think that’s pretty standard…

I guess it doesn’t really matter as long as the prefixes are intuitive and consistent… I was just curious because I’m trying to get better at Excel VBA, I don’t have a book (yet), Excel 2000 Help SUCKS (half the time it doesn’t even show the declarations in the examples…), and I know there are experts on here whose opinions I trust and respect… Every time I declare a worksheet or a range or whatever, I think… “Now what should I be using here… sht for Worksheet… wrksht…. or what??” … I’m just particular (or should I say peculiar) like that…

Reply | Quote

I just make up my own prefixes:

Object	Prefix
Chart	cht
Dialog	dlg
PivotTable	pvt
QueryTable	qtb
Range	rng
Series	ser
Shape	shp
Sheet	sht
Workbook	wbk
Worksheet	wsh

But I reserve the right to deviate from this. Depends on my mood, the phase of the moon, etc.

Reply | Quote

Thanks Hans… This is a great reference for me as I get used to it…

Reply | Quote

Thanks Hans… This is a great reference for me as I get used to it…

Reply | Quote

I just make up my own prefixes:

Object	Prefix
Chart	cht
Dialog	dlg
PivotTable	pvt
QueryTable	qtb
Range	rng
Series	ser
Shape	shp
Sheet	sht
Workbook	wbk
Worksheet	wsh

But I reserve the right to deviate from this. Depends on my mood, the phase of the moon, etc.

Reply | Quote

Here are 2 KB articles from Microsoft:

http://support.microsoft.com/default.aspx?…kb;en-us;110264%5B/url%5D
http://support.microsoft.com/default.aspx?…kb;en-us;173738%5B/url%5D

Though these don’t answer your question either.

I agree with Hans. I try to use particular ones, though i don’t hold myself to them (I am not anal enough to stop myself from being sloppy)
Steve

Reply | Quote

Well I TRY to keep myself from being sloppy… not that it always works…
Thanks for the articles Steve!

Reply | Quote

Well I TRY to keep myself from being sloppy… not that it always works…
Thanks for the articles Steve!

Reply | Quote

Here are 2 KB articles from Microsoft:

http://support.microsoft.com/default.aspx?…kb;en-us;110264%5B/url%5D
http://support.microsoft.com/default.aspx?…kb;en-us;173738%5B/url%5D

Though these don’t answer your question either.

I agree with Hans. I try to use particular ones, though i don’t hold myself to them (I am not anal enough to stop myself from being sloppy)
Steve

Reply | Quote

I try to use prefixes as much as I can force myself to .

I started off with single letter ones and now mix single and three letter prefixes.

What you use is not very important, as long as you try to stick to it.

For XL objects I tend to be lazy, I just use o, as in
Dim oRange as Range

Reply | Quote

I try to use prefixes as much as I can force myself to .

I started off with single letter ones and now mix single and three letter prefixes.

What you use is not very important, as long as you try to stick to it.

For XL objects I tend to be lazy, I just use o, as in
Dim oRange as Range

Reply | Quote

Hmmm… Well thanks anyway Steve…

I personally use…
bln for Boolean
int for Integer
lng for Long
sng for Single
dbl for Double
etc…
I think that’s pretty standard…

I guess it doesn’t really matter as long as the prefixes are intuitive and consistent… I was just curious because I’m trying to get better at Excel VBA, I don’t have a book (yet), Excel 2000 Help SUCKS (half the time it doesn’t even show the declarations in the examples…), and I know there are experts on here whose opinions I trust and respect… Every time I declare a worksheet or a range or whatever, I think… “Now what should I be using here… sht for Worksheet… wrksht…. or what??” … I’m just particular (or should I say peculiar) like that…

Reply | Quote

He suggests prefixing a lower case:
b for Boolean
i for integer
l for Long
s for Single
d for Double
c for Currency
dt for Date/Time
str for String
obj for Object
v for Variant
u for User-defined

His XL2000 book does not really list anything for the XL objects (as was your original question). He is also not consistent in his use of the conventions. He suggests declaring the variables, but frequently does not do this in his code.

Steve

Reply | Quote

Thanks!… I can wait… (I’ve been wondering this for agessssss…)

Reply | Quote

I don’t have it with me right now, but I think that John Walkenbach does in his book MS Excel Power Programming with VBA. I can check tomorrow.

Reply | Quote

Thanks John…

I appreciate that, but that list I know… I’m looking for generally followed naming conventions specifically for Excel Objects… such as prefixes to use when declaring Excel Objects like worksheets and ranges, etc…… For example “Dim someName as Workbook” … Should that object variable name be given a certain prefix? ….and if so, is there a list of such prefixes?

Reply | Quote

Here’s the Reddick conventions.

Reply | Quote