Hi everyone,

Thanks for Joel and Sheeloo for my previous post.

I want to now concatenate a name of enum item and get its value.

So, an example is:

Enum Periodicity
abcWeekly = 52
abcMonthly = 12
abcYearly = 1
End Enum

The reason why I want to do this is 1) get user input of "Monthly" and 2)
add a prefix of "abc" to get a value of "12"!

How can I do that?

I tried Application.Evaluate("abc"&"Monthly"), but in vain...

Thanks in advance!