tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,825
- Office Version
- 365
- 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)