<div>
Is there a way to right click on the cell and perform the calculation? or something providing the ease of use, using a different UI technique???
</div>


Is there a way to right click on the cell and perform the calculation? or something providing the ease of use, using a different UI technique???

<div>
That would work. So would a double-click. Much more straightforward.<br />
<br />
Kevin
</div>


That would work. So would a double-click. Much more straightforward.

Kevin

<div>
<div class="content wysiwyg-content">
We're frequently needing to convert prices between Dollars and Euros or other currency. &nbsp;<br />
<br />
I was wondering if you could write a macro that would allow you to create a mouse-over effect, so when you move your mouse over a cell it would read the value in the cell and convert it to Euros.<br />
<br />
So cell a1 contains $50 the mouse over would show 38.06
</div>
</div>


We're frequently needing to convert prices between Dollars and Euros or other currency.  

I was wondering if you could write a macro that would allow you to create a mouse-over effect, so when you move your mouse over a cell it would read the value in the cell and convert it to Euros.

So cell a1 contains $50 the mouse over would show 38.06

Calculate a value based on the cell your mouse is moving over in excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.