just new: trying to get/set property of class raises compile error expected: identifier or

I just started testing the waters with VBA in excel and I'm having trouble with a very basic custom class. The code worked when the class property was public and I could access it without get/set functions. However, when I switched to a private class property and added the get/set functions to access the private property I get this error:
Compile Error: Expected: identifier or bracketed expression

This is the class module:

Please Login or Register  to view this content.

As soon as I type the period after prevEvent and try to select the property from the menu that pops up I get the error. What am I doing wrong? I am following every tutorial I can find on this basic issue.

Thanks in advance.

Hello himyburneraccount,

Welcome to the forum!

The first thing I see is your property Get does not match your property Let statement. You don't need to use the Private keyword. All variables declared inside a Class are private to the Class module. The code should be...

Please Login or Register  to view this content.

Next, the "New"keyword will instantiate a new Class object when it is executed. Try this code to assign the property a value and then display the value in a message box.

Please Login or Register  to view this content.