declare 'arByte() As Byte' as 'Private Const' ?

[Henry]

Is it possible to declare an array of bytes as as a Private Const ?

 

[Douglas J. Steele]

You can't declare an array as a constant of any type.

 

[Henry]

But can you create a hex constant and code it to an array of bytes, no ?

 

[Douglas J. Steele]

I'm unaware of any way to do that.

 

[John Nurick]

But can you create a hex constant and code it to an array of bytes, no ?

I don't think VBA lets you get closer than garbage like this, using LSet
on variables of user-defined types:

Type tA
A(9) As Byte
End Type

Type tB
S As String * 10
End Type

Const S As String * 10 = "0123456789"

Sub Test()
Dim A As tA
Dim B As tB

B.S = S
LSet A = B
Debug.Print A.A(0), A.A(9)
End Sub