tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,621
- Office Version
-
- 2019
- Platform
-
- Windows
I have this code in two separate userforms but wondered if there is a way I can only write it once somewhere and refer to it.
Code:
Dim MyArray() As Variant
MyArray = Array(1, 2, 3, 4, 5)
Me.LsitBox1.List = MyArray
Erase MyArray)