Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 18th 05, 01:52 AM
GRIFFO
 
Posts: n/a
Default Tool Tip when mouse over

I would like to create / edit a 'tool tip' (little yellow message box like
thing) that occurs when you mouse over a cell in a worksheet.

I have an existing worksheet with this functionality, and would like to
amend it and create new ones and have no idea how. It is not a comment box.

Any Ideas?

Your assistance is appreciated.
Griffo


  #2   Report Post  
Old May 18th 05, 04:45 AM
DonCam65
 
Posts: n/a
Default

With the required cell highlighted
Insert - Hyperlink - Screen Tip - <Enter Text to show
Now when you put the cursor over the cell whatever you enter will appear in
a similar manner to a comment.
You can also select a range of cells (on another page ?) to be show by using
the second part of the Hyperlink option
--
Don C


"GRIFFO" wrote:

I would like to create / edit a 'tool tip' (little yellow message box like
thing) that occurs when you mouse over a cell in a worksheet.

I have an existing worksheet with this functionality, and would like to
amend it and create new ones and have no idea how. It is not a comment box.

Any Ideas?

Your assistance is appreciated.
Griffo

  #3   Report Post  
Old May 18th 05, 06:00 AM
GRIFFO
 
Posts: n/a
Default

Sorry my initial question was not clear or correct.
I need the tool tip to open when the cell has the focus. Not when I mouse
over.
Again I have a worksheet with this current functionality and dont know how
to amend it.

Your assistance is appreciated.
Griffo



"DonCam65" wrote:

With the required cell highlighted
Insert - Hyperlink - Screen Tip - <Enter Text to show
Now when you put the cursor over the cell whatever you enter will appear in
a similar manner to a comment.
You can also select a range of cells (on another page ?) to be show by using
the second part of the Hyperlink option
--
Don C


"GRIFFO" wrote:

I would like to create / edit a 'tool tip' (little yellow message box like
thing) that occurs when you mouse over a cell in a worksheet.

I have an existing worksheet with this functionality, and would like to
amend it and create new ones and have no idea how. It is not a comment box.

Any Ideas?

Your assistance is appreciated.
Griffo

  #4   Report Post  
Old May 18th 05, 06:04 AM
GRIFFO
 
Posts: n/a
Default

Sorry my initial question was not clear or correct.
I need the tool tip to open when the cell has the focus. Not when I mouse
over.
Again I have a worksheet with this current functionality and dont know how
to amend it.

Your assistance is appreciated.
Griffo



"DonCam65" wrote:

With the required cell highlighted
Insert - Hyperlink - Screen Tip - <Enter Text to show
Now when you put the cursor over the cell whatever you enter will appear in
a similar manner to a comment.
You can also select a range of cells (on another page ?) to be show by using
the second part of the Hyperlink option
--
Don C


"GRIFFO" wrote:

I would like to create / edit a 'tool tip' (little yellow message box like
thing) that occurs when you mouse over a cell in a worksheet.

I have an existing worksheet with this functionality, and would like to
amend it and create new ones and have no idea how. It is not a comment box.

Any Ideas?

Your assistance is appreciated.
Griffo

  #5   Report Post  
Old May 18th 05, 09:11 AM
Bob Phillips
 
Posts: n/a
Default

Take a look at the worksheet code module behind the code. Select the sheet
name tab, right-click it and select View code from the menu. You probably
will see some code there.

--
HTH

Bob Phillips

"GRIFFO" wrote in message
...
Sorry my initial question was not clear or correct.
I need the tool tip to open when the cell has the focus. Not when I mouse
over.
Again I have a worksheet with this current functionality and dont know how
to amend it.

Your assistance is appreciated.
Griffo



"DonCam65" wrote:

With the required cell highlighted
Insert - Hyperlink - Screen Tip - <Enter Text to show
Now when you put the cursor over the cell whatever you enter will appear

in
a similar manner to a comment.
You can also select a range of cells (on another page ?) to be show by

using
the second part of the Hyperlink option
--
Don C


"GRIFFO" wrote:

I would like to create / edit a 'tool tip' (little yellow message box

like
thing) that occurs when you mouse over a cell in a worksheet.

I have an existing worksheet with this functionality, and would like

to
amend it and create new ones and have no idea how. It is not a comment

box.

Any Ideas?

Your assistance is appreciated.
Griffo





  #6   Report Post  
Old May 18th 05, 02:26 PM
Dave Peterson
 
Posts: n/a
Default

It sounds like you want the Data|Validation|input message tab.

GRIFFO wrote:

Sorry my initial question was not clear or correct.
I need the tool tip to open when the cell has the focus. Not when I mouse
over.
Again I have a worksheet with this current functionality and dont know how
to amend it.

Your assistance is appreciated.
Griffo

"DonCam65" wrote:

With the required cell highlighted
Insert - Hyperlink - Screen Tip - <Enter Text to show
Now when you put the cursor over the cell whatever you enter will appear in
a similar manner to a comment.
You can also select a range of cells (on another page ?) to be show by using
the second part of the Hyperlink option
--
Don C


"GRIFFO" wrote:

I would like to create / edit a 'tool tip' (little yellow message box like
thing) that occurs when you mouse over a cell in a worksheet.

I have an existing worksheet with this functionality, and would like to
amend it and create new ones and have no idea how. It is not a comment box.

Any Ideas?

Your assistance is appreciated.
Griffo


--

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
Excel Tool Bar Gone sc826 Excel Discussion (Misc queries) 4 April 10th 05 04:31 PM
Mouse continues to select after clicking on a cell in excel. Fletch Excel Discussion (Misc queries) 4 February 22nd 05 03:27 AM
moving mouse highlights cells without touching left mouse button bremboy Excel Discussion (Misc queries) 2 January 27th 05 07:19 PM
moving mouse lighlights cells brentb Excel Discussion (Misc queries) 1 January 17th 05 07:36 PM
moving mouse highlights cells. why? brentb Excel Discussion (Misc queries) 1 January 17th 05 06:34 PM


All times are GMT +1. The time now is 11:41 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017