Is it possible to declare an array of bytes as as a Private Const ?
J John Nurick Dec 21, 2004 #5 But can you create a hex constant and code it to an array of bytes, no ? Click to expand... 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
But can you create a hex constant and code it to an array of bytes, no ? Click to expand... 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