Between 2 cells: if you type on any cell a value to be returned on the second

**tsioumiou** · 11-19-2010, 10:53 AM

Is that possible?

What i want to do is between 2 cells, for example A1, B1, when i type a value on A1 a value to be returned on B1 and when I type on B1 a value to be returned on A1.

Something like a EURO DOLLAR currency converter but for different reasons.

Is there a way to do it with Macros or VBA? (If not with basic excel tools)
Will it be easier to use 2 textboxes for that reason? If yes what kind of code i will need?
I not very good with VBA, i would appreciate any help for the specific code

Thanks in advance for any replies.

**tsioumiou** · 11-19-2010, 02:12 PM

no replies?????

**teylyn** · 11-20-2010, 04:53 AM

tsioumiou,

please allow at least 24 hours before bumping your thread. All members here are volunteers. We all have lives, jobs, families, and weekends.

You can use a macro to achieve your goal. The code below assumes that the exchange rate is stored in cell C2, the Euro value is entered in A2 and the Dollar value in B2.

You can enter either Euro or Dollar, and the respective other currency will be calculated.

Please Login or Register  to view this content.

The code goes into the Sheet module (right-click the sheet tab, select View Code and paste the code into the code window of the VBE)

cheers

**tsioumiou** · 11-22-2010, 08:10 AM

I understand and i appreciate everything that happens in this forum.

Thanks a lot for your help.
It seems thats what i need after i change a few things in the code.
If i find any difficulties i will update.

Regards