problem with syntax on simple Class declarations and Sub declarations

I have been having a hard time figuring out the correct syntax to type in an Excel VBA program. When I type these sort of commands into Excel VBA all text is Red as if there are problems with my usage.

I find a lot of the following type of syntax on the web but can not figure out how to make the same functionality work in Excel. I have written quite a bit of other macros in Excel, but the commands like "GET", "RETURN", "NEW" provide functionality I want to use and can't seem to figure out... Is there a web site that would help with translation that anyone knows about? Is this a VB versus VBA vs .NET problem?

Please Login or Register  to view this content.

or also...

Please Login or Register  to view this content.

or also...

Please Login or Register  to view this content.

I know these could be posted almost as separate questions but rather than flood the board with questions I hoped someone could point me in a general direction. I feel like I am missing something fundamental with the language. I have never used "New", "Public", "Private" declarations.

I have attached an example of a Class module that I am having a hard time getting the "Red" to stop being "red". I don't expect someone to fix everything, but any help would be appreciated.

Thanks a bunch.
Rick

The syntax issues are mainly to do with using VB.Net style syntax in VBA.

You can declare an object and create an New instance by using single line of syntax. But unlike .net you can not pass values into the initialize routine when it is created. You would need to do this on a separate line and write your own Initialize routine to pass the value to.

There is no Override supported.

The name of the new object is the same as the Class code module name. So if you want to use GPS you will need to rename the class module Class1 to GPS.

You will find more information here.
http://www.cpearson.com/Excel/Classes.aspx

Originally Posted by ocean_engineer

Even when I name the first class the same as module name, it is still red. Maybe because of nestled Classes?

Correct. Think of VBA as the old Visual Basic 6 because really that is what it is closest to being in regards to VB.NET.

Nestled classes will not work in VBA, you need each class in its own module.

I don't supposse anyone knows a good reference for translation of VB.NET to VBA? Especially one for dummy's that has before and after examples.

Not off the top of my head, but here is your code translated to VBA below, note that this line cannot be used in VBA:

Public Sub As New (ByVal Degrees As Integer, ByVal Minutes As Integer, ByVal seconds As Double, ByVal Direction As CardinalDirection)

The above line is a constructor and is not supported in VBA.
In VBA, you'd want to make your own Public sub and call it after CreateObject in order to 'initialize' your class.

Example:
=======================

Please Login or Register  to view this content.

=======================


Converted VBA class from the small class and properties you posted:

Please Login or Register  to view this content.