Forum Discussion
Entering Data Type from a cell reference
Hi all, I'm trying to create a currency converter in Excel. I insterted two text boxes (ActiveControls): an input box for the currency to be converted, and an output box for the result. I then ins...
I use a different language version of Excel (Polish) so in my case a semicolon is a proper sign to use in formulas.
Also I checked if the cell formating is text. It turned out to be not.
Now, I tried to use your approach using your Excel file with the Vlookup function. There is only one, strange problem. I created a separate file in which I began coppying your data just to check if I understand the whole mechanics behind the vlookup function. In a row of currency conversions I always get #REF! error despite having the same data, formula which you used. I attached the file with this issue.
Nevertheless, thanks very much for Your response.
I didn't look at your file, maybe I'll try again later when my antivirus protection is fully functional again. Here are all the cells with the formula again... maybe this will help you a bit for the time being.
If it still doesn't work the way you want it to, please let me know.
Thank you for your understanding and patience
