Hi,
I am trying to format a graph, with a user input as a text file. So I parse the string which contains the graph's desired patterns, and retrieve bits such as "msopattern10Percent" - but typed as String.
I would like to convert those strings to MsoPatternType type, and I've came across the [Enum].Parse(Type, String) function which does just that.
Problem, I have to provide the final type required. All that I found is a Visual Basic Operator, GetType, but it is not recognized by VBA. Is there a specific library I have to load? Is there another reason to that?
Thank you very much for your advice!
I am trying to format a graph, with a user input as a text file. So I parse the string which contains the graph's desired patterns, and retrieve bits such as "msopattern10Percent" - but typed as String.
I would like to convert those strings to MsoPatternType type, and I've came across the [Enum].Parse(Type, String) function which does just that.
Problem, I have to provide the final type required. All that I found is a Visual Basic Operator, GetType, but it is not recognized by VBA. Is there a specific library I have to load? Is there another reason to that?
Thank you very much for your advice!
