gravanoc
Active Member
- Joined
- Oct 20, 2015
- Messages
- 346
- Office Version
- 365
- Platform
- Windows
- Mobile
What I am trying to do is store the BackColor property of all of my UserForm's controls, so if I change that property, I can revert back to it later. I would like to do it in the most efficient way possible, and avoid storing the values on a sheet. Currently, I am storing these colors in an array, using the index of the control as the array index. The problem is that I don't know how to do the reverse operation, which is to retrieve the color using the control's index, without using a loop to do so. I felt there had to be a better way, but I might be wrong. I have alternatively tried using custom collections and dictionaries, but feel I'm not doing it right. Any suggestions are welcome, thanks.