Fixed-length strings not allowed as the type of a public member of an object module; private object modules not allowed as the type of a public member of a public object module

This error has the following cause and solution:

• You cannot set the type of a public member of an object module to a fixed-length string. Use a different variable type.

• You cannot set the type of a public member of a public object module to a private object module. Use a different type.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.