Visual Basic For Applications - Array - Push | Pop | Shift | Unshift

Do native speakers use "ultima" and "proxima" frequently in spoken English?

Can a medieval gyroplane be built?

How do hiring committees for research positions view getting "scooped"?

Is there a hypothetical scenario that would make Earth uninhabitable for humans, but not for (the majority of) other animals?

Practical application of matrices and determinants

두음법칙 - When did North and South diverge in pronunciation of initial ㄹ?

Is honey really a supersaturated solution? Does heating to un-crystalize redissolve it or melt it?

Help rendering a complicated sum/product formula

Should I use acronyms in dialogues before telling the readers what it stands for in fiction?

Can other pieces capture a threatening piece and prevent a checkmate?

I got the following comment from a reputed math journal. What does it mean?

When did antialiasing start being available?

How are passwords stolen from companies if they only store hashes?

What does Deadpool mean by "left the house in that shirt"?

Calculate the frequency of characters in a string

What is the English word for a graduation award?

How to generate binary array whose elements with values 1 are randomly drawn

Turning a hard to access nut?

Why didn't Héctor fade away after this character died in the movie Coco?

Is it true that good novels will automatically sell themselves on Amazon (and so on) and there is no need for one to waste time promoting?

Describing a chess game in a novel

Could Sinn Fein swing any Brexit vote in Parliament?

Worshiping one God at a time?

PTIJ What is the inyan of the Konami code in Uncle Moishy's song?



Visual Basic For Applications - Array - Push | Pop | Shift | Unshift














0












$begingroup$


I want to write my snake game procedurally, using as much windows call as I can so as to practice. Looking into GetAsyncKeyState to capture keyboard inputs and play sound functions. Also making a sweet user interface. Fun!



Also shout to bytecomb for providing example as to how to traverse the array structure, used his code function to find ptr to element in array!!



Wrote this to practice!




DECLARATIONS AND FUNCTIONS




Option Explicit

Private Declare PtrSafe Function VarPtrArray Lib "VBE7" Alias "VarPtr" _
(ByRef Var() As Any) As LongPtr

Private Declare PtrSafe Sub CopyMemoryI Lib "kernel32.dll" Alias "RtlMoveMemory" _
(ByVal dst As LongPtr, ByVal src As LongPtr, ByVal Length As Long)

Private Declare PtrSafe Sub CopyMemoryII Lib "kernel32.dll" Alias "RtlMoveMemory" _
(ByRef dst As SAFEARRAY, ByVal src As LongPtr, ByVal Length As Long)

Private Type SAFEARRAY_BOUND
cElements As Long
lLbound As Long
End Type

Private Type SAFEARRAY
cDims As Integer
fFeatures As Integer
cbElements As Long
cLocks As Long
pvData As LongPtr
rgsabound(0) As SAFEARRAY_BOUND
End Type

Private Type SnakePart
Column As Long
Row As Long
End Type

Private Const SNAKEPART_BYTELENGTH = 8
Private SnakeParts() As SnakePart

Private Function ArrayPush(ByRef ArrayOriginal() As SnakePart, ByRef ElementToAdd As SnakePart) As SnakePart()
Dim NewLength As Long
Dim CopiedBytes As Long
Dim NewBytes As Long

NewLength = UBound(ArrayOriginal) + 1
ReDim ArrayPush(NewLength)

CopiedBytes = UBound(ArrayOriginal) * SNAKEPART_BYTELENGTH
NewBytes = SNAKEPART_BYTELENGTH

CopyMemoryI ArrayElementGetPointer(ArrayPush, 0, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal, 0, SNAKEPART_BYTELENGTH), CopiedBytes
CopyMemoryI ArrayElementGetPointer(ArrayPush, UBound(ArrayPush) - 1, SNAKEPART_BYTELENGTH), VarPtr(ElementToAdd), NewBytes
End Function

Private Function ArrayPop(ByRef ArrayOriginal() As SnakePart) As SnakePart()
Dim NewLength As Long
Dim CopiedBytes As Long

NewLength = UBound(ArrayOriginal) - 1
ReDim ArrayPop(NewLength)

CopiedBytes = NewLength * SNAKEPART_BYTELENGTH

CopyMemoryI ArrayElementGetPointer(ArrayPop, 0, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal(), 0, SNAKEPART_BYTELENGTH), CopiedBytes
End Function

Private Function ArrayShift(ByRef ArrayOriginal() As SnakePart, ByRef ElementToAdd As SnakePart) As SnakePart()
Dim NewLength As Long
Dim CopiedBytes As Long
Dim NewBytes As Long

NewLength = UBound(ArrayOriginal) + 1
ReDim ArrayShift(NewLength)

CopiedBytes = UBound(ArrayOriginal) * SNAKEPART_BYTELENGTH
NewBytes = SNAKEPART_BYTELENGTH

CopyMemoryI ArrayElementGetPointer(ArrayShift, 1, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal, 0, SNAKEPART_BYTELENGTH), CopiedBytes
CopyMemoryI ArrayElementGetPointer(ArrayShift, 0, SNAKEPART_BYTELENGTH), VarPtr(ElementToAdd), NewBytes
End Function

Private Function ArrayUnshift(ByRef ArrayOriginal() As SnakePart) As SnakePart()
Dim NewLength As Long
Dim CopiedBytes As Long

NewLength = UBound(ArrayOriginal) - 1
ReDim ArrayUnshift(NewLength)

CopiedBytes = NewLength * SNAKEPART_BYTELENGTH

CopyMemoryI ArrayElementGetPointer(ArrayUnshift, 0, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal, 1, SNAKEPART_BYTELENGTH), CopiedBytes
End Function

Private Function ArrayElementGetPointer(ByRef Arr() As SnakePart, ByVal ElementIndex As Long, ByVal ElementByteLength As Long) As LongPtr
Dim ptrToArrayVar As LongPtr
Dim ptrToSafeArray As LongPtr
Dim ptrToArrayData As LongPtr
Dim ptrCursor As LongPtr
Dim uSAFEARRAY As SAFEARRAY

' Get Pointer To Array *Variable*
ptrToArrayVar = VarPtrArray(Arr)
' Get Pointer To Array Variable *SAFEARRAY* By Directly Reading Array Variable
CopyMemoryI VarPtr(ptrToSafeArray), ptrToArrayVar, 8
' Read The SAFEARRAY Structure
CopyMemoryII uSAFEARRAY, ptrToSafeArray, LenB(uSAFEARRAY)
' Get Pointer To Array Data
ptrToArrayData = uSAFEARRAY.pvData
' Get Pointer To Array Element
ptrCursor = ptrToArrayData + (ElementIndex * ElementByteLength)
ArrayElementGetPointer = ptrCursor
End Function



TESTS




Sub TestFunctions()

Dim Arr(10) As SnakePart
Dim SP As SnakePart
SP.Column = 4
SP.Row = 4
Arr(0) = SP
Debug.Print "Expect 4 x2"
Debug.Print Arr(0).Column
Debug.Print Arr(0).Row

Dim ArrTwo() As SnakePart

SP.Column = 8
SP.Row = 8
ArrTwo = ArrayPush(Arr, SP)

Debug.Print "Expect 4 x2 Followed by 8 x2"
Debug.Print ArrTwo(0).Column
Debug.Print ArrTwo(0).Row
Debug.Print ArrTwo(10).Column
Debug.Print ArrTwo(10).Row

ArrTwo = ArrayPop(Arr)

Debug.Print "Expect 4 x2 Followed by 0 x2"
Debug.Print ArrTwo(0).Column
Debug.Print ArrTwo(0).Row
Debug.Print ArrTwo(9).Column
Debug.Print ArrTwo(9).Row

SP.Column = 7
SP.Row = 7
ArrTwo = ArrayShift(ArrTwo, SP)

Debug.Print "Expect 7 x2 Followed by 4 x2"
Debug.Print ArrTwo(0).Column
Debug.Print ArrTwo(0).Row
Debug.Print ArrTwo(1).Column
Debug.Print ArrTwo(1).Row

ArrTwo = ArrayUnshift(ArrTwo)

Debug.Print "Expect 4 x2 Followed by 0 x2"
Debug.Print ArrTwo(0).Column
Debug.Print ArrTwo(0).Row
Debug.Print ArrTwo(1).Column
Debug.Print ArrTwo(1).Row

End Sub








share









$endgroup$
















    0












    $begingroup$


    I want to write my snake game procedurally, using as much windows call as I can so as to practice. Looking into GetAsyncKeyState to capture keyboard inputs and play sound functions. Also making a sweet user interface. Fun!



    Also shout to bytecomb for providing example as to how to traverse the array structure, used his code function to find ptr to element in array!!



    Wrote this to practice!




    DECLARATIONS AND FUNCTIONS




    Option Explicit

    Private Declare PtrSafe Function VarPtrArray Lib "VBE7" Alias "VarPtr" _
    (ByRef Var() As Any) As LongPtr

    Private Declare PtrSafe Sub CopyMemoryI Lib "kernel32.dll" Alias "RtlMoveMemory" _
    (ByVal dst As LongPtr, ByVal src As LongPtr, ByVal Length As Long)

    Private Declare PtrSafe Sub CopyMemoryII Lib "kernel32.dll" Alias "RtlMoveMemory" _
    (ByRef dst As SAFEARRAY, ByVal src As LongPtr, ByVal Length As Long)

    Private Type SAFEARRAY_BOUND
    cElements As Long
    lLbound As Long
    End Type

    Private Type SAFEARRAY
    cDims As Integer
    fFeatures As Integer
    cbElements As Long
    cLocks As Long
    pvData As LongPtr
    rgsabound(0) As SAFEARRAY_BOUND
    End Type

    Private Type SnakePart
    Column As Long
    Row As Long
    End Type

    Private Const SNAKEPART_BYTELENGTH = 8
    Private SnakeParts() As SnakePart

    Private Function ArrayPush(ByRef ArrayOriginal() As SnakePart, ByRef ElementToAdd As SnakePart) As SnakePart()
    Dim NewLength As Long
    Dim CopiedBytes As Long
    Dim NewBytes As Long

    NewLength = UBound(ArrayOriginal) + 1
    ReDim ArrayPush(NewLength)

    CopiedBytes = UBound(ArrayOriginal) * SNAKEPART_BYTELENGTH
    NewBytes = SNAKEPART_BYTELENGTH

    CopyMemoryI ArrayElementGetPointer(ArrayPush, 0, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal, 0, SNAKEPART_BYTELENGTH), CopiedBytes
    CopyMemoryI ArrayElementGetPointer(ArrayPush, UBound(ArrayPush) - 1, SNAKEPART_BYTELENGTH), VarPtr(ElementToAdd), NewBytes
    End Function

    Private Function ArrayPop(ByRef ArrayOriginal() As SnakePart) As SnakePart()
    Dim NewLength As Long
    Dim CopiedBytes As Long

    NewLength = UBound(ArrayOriginal) - 1
    ReDim ArrayPop(NewLength)

    CopiedBytes = NewLength * SNAKEPART_BYTELENGTH

    CopyMemoryI ArrayElementGetPointer(ArrayPop, 0, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal(), 0, SNAKEPART_BYTELENGTH), CopiedBytes
    End Function

    Private Function ArrayShift(ByRef ArrayOriginal() As SnakePart, ByRef ElementToAdd As SnakePart) As SnakePart()
    Dim NewLength As Long
    Dim CopiedBytes As Long
    Dim NewBytes As Long

    NewLength = UBound(ArrayOriginal) + 1
    ReDim ArrayShift(NewLength)

    CopiedBytes = UBound(ArrayOriginal) * SNAKEPART_BYTELENGTH
    NewBytes = SNAKEPART_BYTELENGTH

    CopyMemoryI ArrayElementGetPointer(ArrayShift, 1, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal, 0, SNAKEPART_BYTELENGTH), CopiedBytes
    CopyMemoryI ArrayElementGetPointer(ArrayShift, 0, SNAKEPART_BYTELENGTH), VarPtr(ElementToAdd), NewBytes
    End Function

    Private Function ArrayUnshift(ByRef ArrayOriginal() As SnakePart) As SnakePart()
    Dim NewLength As Long
    Dim CopiedBytes As Long

    NewLength = UBound(ArrayOriginal) - 1
    ReDim ArrayUnshift(NewLength)

    CopiedBytes = NewLength * SNAKEPART_BYTELENGTH

    CopyMemoryI ArrayElementGetPointer(ArrayUnshift, 0, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal, 1, SNAKEPART_BYTELENGTH), CopiedBytes
    End Function

    Private Function ArrayElementGetPointer(ByRef Arr() As SnakePart, ByVal ElementIndex As Long, ByVal ElementByteLength As Long) As LongPtr
    Dim ptrToArrayVar As LongPtr
    Dim ptrToSafeArray As LongPtr
    Dim ptrToArrayData As LongPtr
    Dim ptrCursor As LongPtr
    Dim uSAFEARRAY As SAFEARRAY

    ' Get Pointer To Array *Variable*
    ptrToArrayVar = VarPtrArray(Arr)
    ' Get Pointer To Array Variable *SAFEARRAY* By Directly Reading Array Variable
    CopyMemoryI VarPtr(ptrToSafeArray), ptrToArrayVar, 8
    ' Read The SAFEARRAY Structure
    CopyMemoryII uSAFEARRAY, ptrToSafeArray, LenB(uSAFEARRAY)
    ' Get Pointer To Array Data
    ptrToArrayData = uSAFEARRAY.pvData
    ' Get Pointer To Array Element
    ptrCursor = ptrToArrayData + (ElementIndex * ElementByteLength)
    ArrayElementGetPointer = ptrCursor
    End Function



    TESTS




    Sub TestFunctions()

    Dim Arr(10) As SnakePart
    Dim SP As SnakePart
    SP.Column = 4
    SP.Row = 4
    Arr(0) = SP
    Debug.Print "Expect 4 x2"
    Debug.Print Arr(0).Column
    Debug.Print Arr(0).Row

    Dim ArrTwo() As SnakePart

    SP.Column = 8
    SP.Row = 8
    ArrTwo = ArrayPush(Arr, SP)

    Debug.Print "Expect 4 x2 Followed by 8 x2"
    Debug.Print ArrTwo(0).Column
    Debug.Print ArrTwo(0).Row
    Debug.Print ArrTwo(10).Column
    Debug.Print ArrTwo(10).Row

    ArrTwo = ArrayPop(Arr)

    Debug.Print "Expect 4 x2 Followed by 0 x2"
    Debug.Print ArrTwo(0).Column
    Debug.Print ArrTwo(0).Row
    Debug.Print ArrTwo(9).Column
    Debug.Print ArrTwo(9).Row

    SP.Column = 7
    SP.Row = 7
    ArrTwo = ArrayShift(ArrTwo, SP)

    Debug.Print "Expect 7 x2 Followed by 4 x2"
    Debug.Print ArrTwo(0).Column
    Debug.Print ArrTwo(0).Row
    Debug.Print ArrTwo(1).Column
    Debug.Print ArrTwo(1).Row

    ArrTwo = ArrayUnshift(ArrTwo)

    Debug.Print "Expect 4 x2 Followed by 0 x2"
    Debug.Print ArrTwo(0).Column
    Debug.Print ArrTwo(0).Row
    Debug.Print ArrTwo(1).Column
    Debug.Print ArrTwo(1).Row

    End Sub








    share









    $endgroup$














      0












      0








      0





      $begingroup$


      I want to write my snake game procedurally, using as much windows call as I can so as to practice. Looking into GetAsyncKeyState to capture keyboard inputs and play sound functions. Also making a sweet user interface. Fun!



      Also shout to bytecomb for providing example as to how to traverse the array structure, used his code function to find ptr to element in array!!



      Wrote this to practice!




      DECLARATIONS AND FUNCTIONS




      Option Explicit

      Private Declare PtrSafe Function VarPtrArray Lib "VBE7" Alias "VarPtr" _
      (ByRef Var() As Any) As LongPtr

      Private Declare PtrSafe Sub CopyMemoryI Lib "kernel32.dll" Alias "RtlMoveMemory" _
      (ByVal dst As LongPtr, ByVal src As LongPtr, ByVal Length As Long)

      Private Declare PtrSafe Sub CopyMemoryII Lib "kernel32.dll" Alias "RtlMoveMemory" _
      (ByRef dst As SAFEARRAY, ByVal src As LongPtr, ByVal Length As Long)

      Private Type SAFEARRAY_BOUND
      cElements As Long
      lLbound As Long
      End Type

      Private Type SAFEARRAY
      cDims As Integer
      fFeatures As Integer
      cbElements As Long
      cLocks As Long
      pvData As LongPtr
      rgsabound(0) As SAFEARRAY_BOUND
      End Type

      Private Type SnakePart
      Column As Long
      Row As Long
      End Type

      Private Const SNAKEPART_BYTELENGTH = 8
      Private SnakeParts() As SnakePart

      Private Function ArrayPush(ByRef ArrayOriginal() As SnakePart, ByRef ElementToAdd As SnakePart) As SnakePart()
      Dim NewLength As Long
      Dim CopiedBytes As Long
      Dim NewBytes As Long

      NewLength = UBound(ArrayOriginal) + 1
      ReDim ArrayPush(NewLength)

      CopiedBytes = UBound(ArrayOriginal) * SNAKEPART_BYTELENGTH
      NewBytes = SNAKEPART_BYTELENGTH

      CopyMemoryI ArrayElementGetPointer(ArrayPush, 0, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal, 0, SNAKEPART_BYTELENGTH), CopiedBytes
      CopyMemoryI ArrayElementGetPointer(ArrayPush, UBound(ArrayPush) - 1, SNAKEPART_BYTELENGTH), VarPtr(ElementToAdd), NewBytes
      End Function

      Private Function ArrayPop(ByRef ArrayOriginal() As SnakePart) As SnakePart()
      Dim NewLength As Long
      Dim CopiedBytes As Long

      NewLength = UBound(ArrayOriginal) - 1
      ReDim ArrayPop(NewLength)

      CopiedBytes = NewLength * SNAKEPART_BYTELENGTH

      CopyMemoryI ArrayElementGetPointer(ArrayPop, 0, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal(), 0, SNAKEPART_BYTELENGTH), CopiedBytes
      End Function

      Private Function ArrayShift(ByRef ArrayOriginal() As SnakePart, ByRef ElementToAdd As SnakePart) As SnakePart()
      Dim NewLength As Long
      Dim CopiedBytes As Long
      Dim NewBytes As Long

      NewLength = UBound(ArrayOriginal) + 1
      ReDim ArrayShift(NewLength)

      CopiedBytes = UBound(ArrayOriginal) * SNAKEPART_BYTELENGTH
      NewBytes = SNAKEPART_BYTELENGTH

      CopyMemoryI ArrayElementGetPointer(ArrayShift, 1, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal, 0, SNAKEPART_BYTELENGTH), CopiedBytes
      CopyMemoryI ArrayElementGetPointer(ArrayShift, 0, SNAKEPART_BYTELENGTH), VarPtr(ElementToAdd), NewBytes
      End Function

      Private Function ArrayUnshift(ByRef ArrayOriginal() As SnakePart) As SnakePart()
      Dim NewLength As Long
      Dim CopiedBytes As Long

      NewLength = UBound(ArrayOriginal) - 1
      ReDim ArrayUnshift(NewLength)

      CopiedBytes = NewLength * SNAKEPART_BYTELENGTH

      CopyMemoryI ArrayElementGetPointer(ArrayUnshift, 0, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal, 1, SNAKEPART_BYTELENGTH), CopiedBytes
      End Function

      Private Function ArrayElementGetPointer(ByRef Arr() As SnakePart, ByVal ElementIndex As Long, ByVal ElementByteLength As Long) As LongPtr
      Dim ptrToArrayVar As LongPtr
      Dim ptrToSafeArray As LongPtr
      Dim ptrToArrayData As LongPtr
      Dim ptrCursor As LongPtr
      Dim uSAFEARRAY As SAFEARRAY

      ' Get Pointer To Array *Variable*
      ptrToArrayVar = VarPtrArray(Arr)
      ' Get Pointer To Array Variable *SAFEARRAY* By Directly Reading Array Variable
      CopyMemoryI VarPtr(ptrToSafeArray), ptrToArrayVar, 8
      ' Read The SAFEARRAY Structure
      CopyMemoryII uSAFEARRAY, ptrToSafeArray, LenB(uSAFEARRAY)
      ' Get Pointer To Array Data
      ptrToArrayData = uSAFEARRAY.pvData
      ' Get Pointer To Array Element
      ptrCursor = ptrToArrayData + (ElementIndex * ElementByteLength)
      ArrayElementGetPointer = ptrCursor
      End Function



      TESTS




      Sub TestFunctions()

      Dim Arr(10) As SnakePart
      Dim SP As SnakePart
      SP.Column = 4
      SP.Row = 4
      Arr(0) = SP
      Debug.Print "Expect 4 x2"
      Debug.Print Arr(0).Column
      Debug.Print Arr(0).Row

      Dim ArrTwo() As SnakePart

      SP.Column = 8
      SP.Row = 8
      ArrTwo = ArrayPush(Arr, SP)

      Debug.Print "Expect 4 x2 Followed by 8 x2"
      Debug.Print ArrTwo(0).Column
      Debug.Print ArrTwo(0).Row
      Debug.Print ArrTwo(10).Column
      Debug.Print ArrTwo(10).Row

      ArrTwo = ArrayPop(Arr)

      Debug.Print "Expect 4 x2 Followed by 0 x2"
      Debug.Print ArrTwo(0).Column
      Debug.Print ArrTwo(0).Row
      Debug.Print ArrTwo(9).Column
      Debug.Print ArrTwo(9).Row

      SP.Column = 7
      SP.Row = 7
      ArrTwo = ArrayShift(ArrTwo, SP)

      Debug.Print "Expect 7 x2 Followed by 4 x2"
      Debug.Print ArrTwo(0).Column
      Debug.Print ArrTwo(0).Row
      Debug.Print ArrTwo(1).Column
      Debug.Print ArrTwo(1).Row

      ArrTwo = ArrayUnshift(ArrTwo)

      Debug.Print "Expect 4 x2 Followed by 0 x2"
      Debug.Print ArrTwo(0).Column
      Debug.Print ArrTwo(0).Row
      Debug.Print ArrTwo(1).Column
      Debug.Print ArrTwo(1).Row

      End Sub








      share









      $endgroup$




      I want to write my snake game procedurally, using as much windows call as I can so as to practice. Looking into GetAsyncKeyState to capture keyboard inputs and play sound functions. Also making a sweet user interface. Fun!



      Also shout to bytecomb for providing example as to how to traverse the array structure, used his code function to find ptr to element in array!!



      Wrote this to practice!




      DECLARATIONS AND FUNCTIONS




      Option Explicit

      Private Declare PtrSafe Function VarPtrArray Lib "VBE7" Alias "VarPtr" _
      (ByRef Var() As Any) As LongPtr

      Private Declare PtrSafe Sub CopyMemoryI Lib "kernel32.dll" Alias "RtlMoveMemory" _
      (ByVal dst As LongPtr, ByVal src As LongPtr, ByVal Length As Long)

      Private Declare PtrSafe Sub CopyMemoryII Lib "kernel32.dll" Alias "RtlMoveMemory" _
      (ByRef dst As SAFEARRAY, ByVal src As LongPtr, ByVal Length As Long)

      Private Type SAFEARRAY_BOUND
      cElements As Long
      lLbound As Long
      End Type

      Private Type SAFEARRAY
      cDims As Integer
      fFeatures As Integer
      cbElements As Long
      cLocks As Long
      pvData As LongPtr
      rgsabound(0) As SAFEARRAY_BOUND
      End Type

      Private Type SnakePart
      Column As Long
      Row As Long
      End Type

      Private Const SNAKEPART_BYTELENGTH = 8
      Private SnakeParts() As SnakePart

      Private Function ArrayPush(ByRef ArrayOriginal() As SnakePart, ByRef ElementToAdd As SnakePart) As SnakePart()
      Dim NewLength As Long
      Dim CopiedBytes As Long
      Dim NewBytes As Long

      NewLength = UBound(ArrayOriginal) + 1
      ReDim ArrayPush(NewLength)

      CopiedBytes = UBound(ArrayOriginal) * SNAKEPART_BYTELENGTH
      NewBytes = SNAKEPART_BYTELENGTH

      CopyMemoryI ArrayElementGetPointer(ArrayPush, 0, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal, 0, SNAKEPART_BYTELENGTH), CopiedBytes
      CopyMemoryI ArrayElementGetPointer(ArrayPush, UBound(ArrayPush) - 1, SNAKEPART_BYTELENGTH), VarPtr(ElementToAdd), NewBytes
      End Function

      Private Function ArrayPop(ByRef ArrayOriginal() As SnakePart) As SnakePart()
      Dim NewLength As Long
      Dim CopiedBytes As Long

      NewLength = UBound(ArrayOriginal) - 1
      ReDim ArrayPop(NewLength)

      CopiedBytes = NewLength * SNAKEPART_BYTELENGTH

      CopyMemoryI ArrayElementGetPointer(ArrayPop, 0, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal(), 0, SNAKEPART_BYTELENGTH), CopiedBytes
      End Function

      Private Function ArrayShift(ByRef ArrayOriginal() As SnakePart, ByRef ElementToAdd As SnakePart) As SnakePart()
      Dim NewLength As Long
      Dim CopiedBytes As Long
      Dim NewBytes As Long

      NewLength = UBound(ArrayOriginal) + 1
      ReDim ArrayShift(NewLength)

      CopiedBytes = UBound(ArrayOriginal) * SNAKEPART_BYTELENGTH
      NewBytes = SNAKEPART_BYTELENGTH

      CopyMemoryI ArrayElementGetPointer(ArrayShift, 1, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal, 0, SNAKEPART_BYTELENGTH), CopiedBytes
      CopyMemoryI ArrayElementGetPointer(ArrayShift, 0, SNAKEPART_BYTELENGTH), VarPtr(ElementToAdd), NewBytes
      End Function

      Private Function ArrayUnshift(ByRef ArrayOriginal() As SnakePart) As SnakePart()
      Dim NewLength As Long
      Dim CopiedBytes As Long

      NewLength = UBound(ArrayOriginal) - 1
      ReDim ArrayUnshift(NewLength)

      CopiedBytes = NewLength * SNAKEPART_BYTELENGTH

      CopyMemoryI ArrayElementGetPointer(ArrayUnshift, 0, SNAKEPART_BYTELENGTH), ArrayElementGetPointer(ArrayOriginal, 1, SNAKEPART_BYTELENGTH), CopiedBytes
      End Function

      Private Function ArrayElementGetPointer(ByRef Arr() As SnakePart, ByVal ElementIndex As Long, ByVal ElementByteLength As Long) As LongPtr
      Dim ptrToArrayVar As LongPtr
      Dim ptrToSafeArray As LongPtr
      Dim ptrToArrayData As LongPtr
      Dim ptrCursor As LongPtr
      Dim uSAFEARRAY As SAFEARRAY

      ' Get Pointer To Array *Variable*
      ptrToArrayVar = VarPtrArray(Arr)
      ' Get Pointer To Array Variable *SAFEARRAY* By Directly Reading Array Variable
      CopyMemoryI VarPtr(ptrToSafeArray), ptrToArrayVar, 8
      ' Read The SAFEARRAY Structure
      CopyMemoryII uSAFEARRAY, ptrToSafeArray, LenB(uSAFEARRAY)
      ' Get Pointer To Array Data
      ptrToArrayData = uSAFEARRAY.pvData
      ' Get Pointer To Array Element
      ptrCursor = ptrToArrayData + (ElementIndex * ElementByteLength)
      ArrayElementGetPointer = ptrCursor
      End Function



      TESTS




      Sub TestFunctions()

      Dim Arr(10) As SnakePart
      Dim SP As SnakePart
      SP.Column = 4
      SP.Row = 4
      Arr(0) = SP
      Debug.Print "Expect 4 x2"
      Debug.Print Arr(0).Column
      Debug.Print Arr(0).Row

      Dim ArrTwo() As SnakePart

      SP.Column = 8
      SP.Row = 8
      ArrTwo = ArrayPush(Arr, SP)

      Debug.Print "Expect 4 x2 Followed by 8 x2"
      Debug.Print ArrTwo(0).Column
      Debug.Print ArrTwo(0).Row
      Debug.Print ArrTwo(10).Column
      Debug.Print ArrTwo(10).Row

      ArrTwo = ArrayPop(Arr)

      Debug.Print "Expect 4 x2 Followed by 0 x2"
      Debug.Print ArrTwo(0).Column
      Debug.Print ArrTwo(0).Row
      Debug.Print ArrTwo(9).Column
      Debug.Print ArrTwo(9).Row

      SP.Column = 7
      SP.Row = 7
      ArrTwo = ArrayShift(ArrTwo, SP)

      Debug.Print "Expect 7 x2 Followed by 4 x2"
      Debug.Print ArrTwo(0).Column
      Debug.Print ArrTwo(0).Row
      Debug.Print ArrTwo(1).Column
      Debug.Print ArrTwo(1).Row

      ArrTwo = ArrayUnshift(ArrTwo)

      Debug.Print "Expect 4 x2 Followed by 0 x2"
      Debug.Print ArrTwo(0).Column
      Debug.Print ArrTwo(0).Row
      Debug.Print ArrTwo(1).Column
      Debug.Print ArrTwo(1).Row

      End Sub






      performance vba excel winapi





      share












      share










      share



      share










      asked 2 mins ago









      learnAsWeGolearnAsWeGo

      2737




      2737




















          0






          active

          oldest

          votes











          Your Answer





          StackExchange.ifUsing("editor", function ()
          return StackExchange.using("mathjaxEditing", function ()
          StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix)
          StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["\$", "\$"]]);
          );
          );
          , "mathjax-editing");

          StackExchange.ifUsing("editor", function ()
          StackExchange.using("externalEditor", function ()
          StackExchange.using("snippets", function ()
          StackExchange.snippets.init();
          );
          );
          , "code-snippets");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "196"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcodereview.stackexchange.com%2fquestions%2f215646%2fvisual-basic-for-applications-array-push-pop-shift-unshift%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Code Review Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          Use MathJax to format equations. MathJax reference.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fcodereview.stackexchange.com%2fquestions%2f215646%2fvisual-basic-for-applications-array-push-pop-shift-unshift%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          कुँवर स्रोत दिक्चालन सूची"कुँवर""राणा कुँवरके वंशावली"

          Why is a white electrical wire connected to 2 black wires?How to wire a light fixture with 3 white wires in box?How should I wire a ceiling fan when there's only three wires in the box?Two white, two black, two ground, and red wire in ceiling box connected to switchWhy is there a white wire connected to multiple black wires in my light box?How to wire a light with two white wires and one black wireReplace light switch connected to a power outlet with dimmer - two black wires to one black and redHow to wire a light with multiple black/white/green wires from the ceiling?Ceiling box has 2 black and white wires but fan/ light only has 1 of eachWhy neutral wire connected to load wire?Switch with 2 black, 2 white, 2 ground and 1 red wire connected to ceiling light and a receptacle?

          चैत्य भूमि चित्र दीर्घा सन्दर्भ बाहरी कडियाँ दिक्चालन सूची"Chaitya Bhoomi""Chaitya Bhoomi: Statue of Equality in India""Dadar Chaitya Bhoomi: Statue of Equality in India""Ambedkar memorial: Centre okays transfer of Indu Mill land"चैत्यभमि