Interactive worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To protect user's privacy 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel 2013 Merge Data 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Sheet protected - user cannot interact 3
Chart events 2
Double Click Event Error on Worksheet 2
Call a cmdSend_Click macro; non-click interaction 5

Back
Top