Can't get Property to compile

[AlexanderBB]

Going slowly mad...

Private pMDFHeader As String

'Assign a value ??
Public Property Let MDFHeader(Value As String)
    pMDFHeader = Value
End Property

'Read the value ??
Public Property Get MDFHeader()
    MDFHeader = pMDFHeader
End Property

and the error I get is

Compile error:
Definitions of property procedures for the same property are
inconsistent, or property procedure has an optional parameter, a
ParamArray, or an invalid Set final parameter

Could someone please tell me what I'm doing wrong ?

 

[RoryA]

Your Property Get should be returning a String:

Public Property Get MDFHeader() As String

to match the input variable type of the Property Let.

 

[AlexanderBB]

Ah Rory, it seems so obvious now. Many thanks