Interactive worksheet
 

Hello and thank you in advance for the help!

I am currently working with a worksheet that shows data. When i double
click on the data, an excel chart pops up in another sheet. This was done
using vba. I'd like to make the data worksheet a little more interactive.
When the user is pointing the arrow over a cell, i'd like the font or
something to change to show the user that something could happen if he/she
decides to click on the cell.

Can i use vb or javascript to achieve this and what is the code for it?

Interactive worksheet
 

Excel does not allow you to code against a MouseMove event so that you may do
things when the mouse moves over a certain cell. However, Excel does allow
you to do various things on a change event - when the value of the cell
changes or on SelectionChange event - that is when clicks on a new cell.

Alok Joshi

"Interactivity" wrote:

Hello and thank you in advance for the help!

I am currently working with a worksheet that shows data. When i double
click on the data, an excel chart pops up in another sheet. This was done
using vba. I'd like to make the data worksheet a little more interactive.
When the user is pointing the arrow over a cell, i'd like the font or
something to change to show the user that something could happen if he/she
decides to click on the cell.

Can i use vb or javascript to achieve this and what is the code for it?

Interactive worksheet
 

Take a look here,

http://groups.google.com.au/group/mi...b44f8ee8e8937/

Beware though that the SetTimer function can be very unstable in Excel's
environment. Save your work often !

Regards,
Vic Eldridge


"Interactivity" wrote:

Hello and thank you in advance for the help!

I am currently working with a worksheet that shows data. When i double
click on the data, an excel chart pops up in another sheet. This was done
using vba. I'd like to make the data worksheet a little more interactive.
When the user is pointing the arrow over a cell, i'd like the font or
something to change to show the user that something could happen if he/she
decides to click on the cell.

Can i use vb or javascript to achieve this and what is the code for it?