Hi,
Excel 2007. I am working on a form that shows the value of cells in textboxes. It will be used in several countries, so TRUE must be WAAR in Dutch. No big issue for most datatypes. But values like #N/A and #DIV/0! keep me puzzled.
To get #N/A in a cell as the Dutch #N/B I use
[a1].value = CVErr(xlErrNA)
Works just fine. And now I can use
s = [a1].formulalocal
to get my Dutch #N/B into a string or textbox. So far so good.
But... now #N/A is in a cell as the result of a formula like lookup. Then I can't use formulalocal. Is there a simple way to retrieve #N/B ?
I tried things like Cstr(CVErr(xlErrNA)) but they give "Fout 2042", and I want "#N/B". Is there something I overlooked?
Thanks for reading and helping!
Excel 2007. I am working on a form that shows the value of cells in textboxes. It will be used in several countries, so TRUE must be WAAR in Dutch. No big issue for most datatypes. But values like #N/A and #DIV/0! keep me puzzled.
To get #N/A in a cell as the Dutch #N/B I use
[a1].value = CVErr(xlErrNA)
Works just fine. And now I can use
s = [a1].formulalocal
to get my Dutch #N/B into a string or textbox. So far so good.
But... now #N/A is in a cell as the result of a formula like lookup. Then I can't use formulalocal. Is there a simple way to retrieve #N/B ?
I tried things like Cstr(CVErr(xlErrNA)) but they give "Fout 2042", and I want "#N/B". Is there something I overlooked?
Thanks for reading and helping!
