Naming convention in VB

[MaxEd]

Hi,

This is my first post. My friend introduced me to this website and I found plenty of great information. Ok here's my question. I have recently started doing some programming in VBA and I sort of lost my ways in the naming convention used on variables. Could someone enlighten me on the naming conventions that programmers are using these days? thank you!

Ed

 

[segmentationfault]

In VB, the convention is to use a letter for the scope, the an abbreviated data type as a prefix, and a mixed case name.

For example,

 ' Global variables
 Public glngSuperCount as Long
 
 ' Procedure scope variables
 Dim pintCounter as Integer
 Dim pdlbValue as Double
 Dim pstrLastName as String

That said, omit almost all prefixes and use a mixed case name.

 

[ratman]

Do you mean declaring variables?
As in:

Dim thename As String
Dim lastrow As Long

thisvar As Global

Public lastrow As Long

 

[MaxEd]

ratman,

I have no problem declaring variables but I would like to learn how to give them proper names to indicate what the type of string they are. I have read books where they tell you to call your variables "myInput" and such. Thanks for your input though.

segmentationdefault,
That answers my question. Thank you!

 

[tcalbaz]

Hi MaxEd
Try these web sites for the information you want.

http://www.hitmill.com/programming/vb/Hungarian.html

http://visualbasic.about.com/library/weekly/blhungarian.htm

Hope it helps

Ted

 

[Loomah]

Hi & welcome!
This isn't exactly what you're looking for but it may be useful in connection with what you're looking for (if that makes sense?)

Anyway

http://www.cpearson.com/excel/variables.htm

I've never gone as far as using p & g for procedure & global but I like the idea of "pintCounter"

Happy Friday
;-) If a man says something and there are no women there to hear him, is he still wrong?