creating a public constant by concatenating string......gives compile error

**welchs101** · 11-26-2011, 06:23 AM

I am trying to create a constant such as the following but it gives me an error

Public Const Valid_appendixsub_inputfile = "Appendix " & Chr(10) & "Subcategory"

any ideas why?

**royUK** · 11-26-2011, 06:28 AM

You can't define a Constant or Variable like that

**welchs101** · 11-26-2011, 07:10 AM

ok. any suggestions on what to do?

**royUK** · 11-26-2011, 07:23 AM

Not really sure what you are doing but maybe

Option Explicit

Public appendixsub_inputfile As String
Function InitVar() As Boolean
    appendixsub_inputfile = "Appendix " & Chr(10) & "Subcategory"
    InitVar = True
End Function
Sub Test()
    If Not InitVar Then InitVar
    MsgBox appendixsub_inputfile
End Sub