I need to define some UDTs like:
Code:
Type Elem_Options
    Option1 As Boolean
    Option2 As Boolean
    Option3 As Boolean
    Option4 As Boolean
    Option5 As Boolean
    Option6 As Boolean
    Option7 As Boolean
    Option8 As Boolean
    Option9 As Boolean
    Option10 As Boolean
    Option11 As Boolean
    Option12 As Boolean
    Option13 As Boolean
    Option14 As Boolean
End Type

Private m_ElemOptions(1000000) As Elem_Options
Elem_Options needs to occupy 28 bytes. If I change Boolean to Byte, Elem_Options only need to occupy 14 bytes:
Code:
Type MyOptions
    Option1 As Byte
    Option2 As Byte
    Option3 As Byte
    Option4 As Byte
    Option5 As Byte
    Option6 As Byte
    Option7 As Byte
    Option8 As Byte
    Option9 As Byte
    Option10 As Byte
    Option11 As Byte
    Option12 As Byte
    Option13 As Byte
    Option14 As Byte
End Type

Private m_ElemOptions(1000000) As Elem_Options
I'd like to know the advantages and disadvantages of the above two methods. After changing Boolean to Byte, will it affect the performance of the software? Thanks !

Also, is it necessary to change Byte to Bit?