Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Excel VBA Class Properties

Hi

I have gathered that a class eg Employee can have properties eg Employee.Address and Employee.Number

So Once I instantiate a new Employee I can assign properties
eg Employee.Address = "31 Crescent Way....

but what is the use of this as when the class terminates this dissapears. How are these properties beneficial? Are they meant to be used in further conditional code or stored in a database etc?

Thanks
Avatar of redmondb
redmondb
Flag of Afghanistan image

Hi, murbro.

You don't terminate the class until you're finished with the data or you have saved it (whether that be to a sreadsheet, file or whatever). In that sense, it's no different to an ordinary variable.

Regards,
Brian.
ASKER CERTIFIED SOLUTION
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Murray Brown

ASKER

Thanks