Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Interactive worksheet
 
Posts: n/a
Default Interactive Worksheet

Is there a way for cells to change format or font when the mouse pointer is
over that particular cell?
  #2   Report Post  
Gary Brown
 
Posts: n/a
Default

Only by using VBA (Visual Basic for applications)
HTH,
--
Gary Brown



"Interactive worksheet" wrote:

Is there a way for cells to change format or font when the mouse pointer is
over that particular cell?

  #3   Report Post  
Interactive worksheet
 
Posts: n/a
Default

Gary,

How long and difficult is the code? Can you give me a vb code that will do
what i want for just one cell?

"Gary Brown" wrote:

Only by using VBA (Visual Basic for applications)
HTH,
--
Gary Brown



"Interactive worksheet" wrote:

Is there a way for cells to change format or font when the mouse pointer is
over that particular cell?

  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

Not by just moving the mouse over the cell. You could do something that would
change the format when the cell is selected (either by mouse or by keyboard).

If you're looking for something that would make the selected cell stand out
better, you may want to try Chip Pearson's utility:

http://www.cpearson.com/excel/RowLiner.htm

Interactive worksheet wrote:

Is there a way for cells to change format or font when the mouse pointer is
over that particular cell?


--

Dave Peterson
  #5   Report Post  
Interactive worksheet
 
Posts: n/a
Default

This RowLiner is a good idea but unfortunately, the excel file is going to be
used by other people and i am assuming that if they dont have rowliner
installed, it's not going to work on their work stations. There is no code
in vb that i can use to make a cell stick out when the mouse pointer scrolls
over the contents of a cell?



"Dave Peterson" wrote:

Not by just moving the mouse over the cell. You could do something that would
change the format when the cell is selected (either by mouse or by keyboard).

If you're looking for something that would make the selected cell stand out
better, you may want to try Chip Pearson's utility:

http://www.cpearson.com/excel/RowLiner.htm

Interactive worksheet wrote:

Is there a way for cells to change format or font when the mouse pointer is
over that particular cell?


--

Dave Peterson



  #6   Report Post  
Dave Peterson
 
Posts: n/a
Default

Not in regular VBA--maybe using some highfalutin' API calls (way beyond me!)
would work.

If it's only certain cells, you could add comments to those cells. When you
mouse over a cell with a comment, the comment pops up (tools|options|View
tab|comment indicator only checked)

Interactive worksheet wrote:

This RowLiner is a good idea but unfortunately, the excel file is going to be
used by other people and i am assuming that if they dont have rowliner
installed, it's not going to work on their work stations. There is no code
in vb that i can use to make a cell stick out when the mouse pointer scrolls
over the contents of a cell?

"Dave Peterson" wrote:

Not by just moving the mouse over the cell. You could do something that would
change the format when the cell is selected (either by mouse or by keyboard).

If you're looking for something that would make the selected cell stand out
better, you may want to try Chip Pearson's utility:

http://www.cpearson.com/excel/RowLiner.htm

Interactive worksheet wrote:

Is there a way for cells to change format or font when the mouse pointer is
over that particular cell?


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
How do I collect data from an interactive web worksheet and impor. worksheetmom Excel Discussion (Misc queries) 3 February 20th 05 01:38 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 06:37 AM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 02:23 PM
Office 2003 will not view interactive Worksheet saved as a web pa. Javier Colunga Excel Worksheet Functions 0 November 10th 04 11:59 PM


All times are GMT +1. The time now is 10:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"