VBA userform to return variable for another sub

[Marmit424]

Hi,

In a set of code, I have several variables tied to arrays. Ex:
- Color1 = Array(23,42,45)
- Color2 = Array(43,23,67)

Separately, I would like to enable others to choose between Color1 and Color2 if they want to, but not have to mess with any code and not have to select the color every time. To that end, I'm trying to build a userform that allows them to select which color they would like. My problem is that the users selection gets returned as a string "Color2" which no longer pulls the array.

So essentially I'm curious if there is either a way to get userform controls to return Color2 rather than "Color2". If not, is there another way to do this I'm not considering?

Thanks!

 

[Marmit424]

Quick update!

I realized that I could nest the user returned value in an if statement to get around this. For instance:
If UserInput = "Color1" Then
SelectedTheme = Color1

Problem solved!