https://bugs.documentfoundation.org/show_bug.cgi?id=166146
--- Comment #3 from [email protected] --- (In reply to Mike Kaganski from comment #2) > The bug is titled > > > Public constants SEEM to be treated as variables > > But actually, it seems like the "Public Const" is not treated as one would > expect, and is equivalent to simply "Const", so in the other module, that > name is not known; and the code > > Private Const MyConstant2 = vbOKOnly ' Syntax Error? > > works just the same as e.g. > > Private Const MyConstant2 = abracadabra ' Syntax Error? > > My assumption is, that these decorations (Private, too) are ignored at > constants... But, this works. private sub ShowSomeConstants() dim aStrings As Variant aStrings=Array( _ "vbOKOnly = " & vbOKOnly, _ "vbInformation = " & vbInformation _ ) MsgBox Join(aStrings, vbCrLf) end sub No syntax error(s), even if I let the system define vbOKOnly and vbInformation. -- You are receiving this mail because: You are the assignee for the bug.
