I know these can't be done in VBA but in my current project I have a number of cases where a string based enumeration would save a lot of sideways coding.

So this is really a question of how do you program around such a restriction.