Originally Posted by
nitt1995
This is getting close to what I am after. Now, lets say that I want to pass an enumeration as an argument, and I want to be able to call this function from within VBA.
[vba]Dim ci as myColours
set ci = xlCIBlack
Application.Run(ColourName, ci)[/vba]
I need to pass the myColours enumeration into the Application.Run method. I need a way to cycle through each of the enumeration options in this code so I can return the values from various enumeration entities.
Therefore, using the myColours Enumeration example, I would want to pass xlCITeal like : Application.Run(ColourName, xlCITeal ) to return "Teal" as a string. The next time, I might pass Application.Run(ColourName, xlCIBrightGreen) to return "green" as a string, etc....