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
$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
performance vba excel winapi
$endgroup$
add a comment |
$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
performance vba excel winapi
$endgroup$
add a comment |
$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
performance vba excel winapi
$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
performance vba excel winapi
asked 2 mins ago
learnAsWeGolearnAsWeGo
2737
2737
add a comment |
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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