Is it possible to change the colour of a cell?

  • Thread starter Thread starter hce
  • Start date Start date
H

hce

Hi Excel Experts

Is it possible for a cell to change colour when the cursor is place
over it? Normally, a cell colour is normally in white. I would like t
create a cell whereby once the cursor is placed over that particula
cell, it would be filled in red for example. The reason for this is
have "tied" some code to the cell and if the cell is double clicked
the code will run. Hence, I would like to make some differentiatio
between these cells to the normal cells without any code attached t
them. Please don't suggest using buttons as I don't want to use them
However, it would also be great if the cursor is able to change shap
once it's placed over these special cells. Unfortunately, after days o
trying, I have still not able to figure this out. So it's eithe
getting the cursor shape to change or to make the cell backgroun
colour change or colour of the value in the cell change... Guys!!! An
clue?

Cheer
 
I think you will find that the Excel worksheet doesn't know or car
where your cursor is unless it clicks on a cell or a menu or a char
etc to register its presence or its wishes.

If you want the terrain to know when you are flying over it, you wil
have to look to VBA and VB objects (though they don't have to b
buttons - ever seen an invisible hotspot? );)

Al
 
Hi
don't think this is possible. you may use the Selection_change event to
color the active cell but this will require additional code for this
worksheet
 
This is a stretch, but you could associate a hyperlink
that refers to itself - that is, the same cell address
in the same sheet. The cursor changes to the pointing
hand (but the value in the cell may have a color change
and be underlined like a true hyperlink).
I tried it, and code can be associated with the click
as per normal.

Worth a try?
jr
 
Once again, the Excel Experts have lived up to their reputation!!! Th
hyperlink thingy worked perfectly and it really solved all m
problems... I have also learnt new things from other comments... Than
you so MUCH!!
 

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

Back
Top