I have a problem that I am sure isn't unique.

I have a userform with a refedit in and when I bring up the form from
a cell that holds a formula I would like to initialise the refedit
with something that is in the formula. E.g. lets say I want the second
parameter of the main function in the formula.

The easiest way to parse this is by getting rCell.Formula and looking
for paranthesis and commas (standard lists).

But then I want to use that parameter and place it into the refedit
that is both in the local language and in the users reference style. I
can use ConvertFormula to change it to the correct reference style,
but how do I convert from VBA language to the local language.

I also need to convert it back as when the refedit changes I would
like to display the result of the refedit text. I can do that easily
in VBA language (US_EN) using Application.Evaluate but I need to
convert the refedit text from the local language back to VBA language.

The refedit text could be anything, a number, actual text, a formula
or even an array (e.g. {1,2,3,4} or {1\2\3\4} if the decimal point is
a comma as it is in most european countries). It could even be a range
in R1C1 style in which the R or C is in the local language (e.g.
german would be Z1S1) so I don't really want to parse a local formula.

Thanks for any help in advance.


Alan