ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   mouse over pop up (https://www.excelbanter.com/excel-discussion-misc-queries/125827-mouse-over-pop-up.html)

oxicottin

mouse over pop up
 
Is there any way I can run my mouse over a section and have a pop up appear
"say a small picture" for a few seconds and then close? Im am not good at
macros so if so can you explain in steps?

Thanks!

Teethless mama

mouse over pop up
 
Insert Comment Back spaces to clear inside the comment click out the
border right click format comment Colors and Lines tab click the drop
down under Fill Color: select Fill Effects select Picture tab click on
Select Picture button select any picture you want click Insert Ok OK

Evertime you your mouse over the comment the picture will pop up

"oxicottin" wrote:

Is there any way I can run my mouse over a section and have a pop up appear
"say a small picture" for a few seconds and then close? Im am not good at
macros so if so can you explain in steps?

Thanks!


oxicottin

mouse over pop up
 
Thanks I now I know how to do this but even by adding my picture to a comment
box there still is that little triange in the corner. How do you get rid of
it? Thanks for your reply!!!

"Teethless mama" wrote:

Insert Comment Back spaces to clear inside the comment click out the
border right click format comment Colors and Lines tab click the drop
down under Fill Color: select Fill Effects select Picture tab click on
Select Picture button select any picture you want click Insert Ok OK

Evertime you your mouse over the comment the picture will pop up

"oxicottin" wrote:

Is there any way I can run my mouse over a section and have a pop up appear
"say a small picture" for a few seconds and then close? Im am not good at
macros so if so can you explain in steps?

Thanks!


Dave Peterson

mouse over pop up
 
The red indicator indicates that there is a comment in that cell.

You can use:
tools|Options|View tab|Comment section

to hide the comment, to show the indicator only (the comment will appear when
you mouse over the cell) or to show both the indicator and the comment.

You'll notice that there isn't an option to hide the comment indicator, but
still allow the comment to appear.

oxicottin wrote:

Thanks I now I know how to do this but even by adding my picture to a comment
box there still is that little triange in the corner. How do you get rid of
it? Thanks for your reply!!!

"Teethless mama" wrote:

Insert Comment Back spaces to clear inside the comment click out the
border right click format comment Colors and Lines tab click the drop
down under Fill Color: select Fill Effects select Picture tab click on
Select Picture button select any picture you want click Insert Ok OK

Evertime you your mouse over the comment the picture will pop up

"oxicottin" wrote:

Is there any way I can run my mouse over a section and have a pop up appear
"say a small picture" for a few seconds and then close? Im am not good at
macros so if so can you explain in steps?

Thanks!


--

Dave Peterson

drmikec

mouse over pop up
 


"Dave Peterson" wrote:

The red indicator indicates that there is a comment in that cell.

You can use:
tools|Options|View tab|Comment section

to hide the comment, to show the indicator only (the comment will appear when
you mouse over the cell) or to show both the indicator and the comment.

You'll notice that there isn't an option to hide the comment indicator, but
still allow the comment to appear.

oxicottin wrote:

Thanks I now I know how to do this but even by adding my picture to a comment
box there still is that little triange in the corner. How do you get rid of
it? Thanks for your reply!!!

"Teethless mama" wrote:

Insert Comment Back spaces to clear inside the comment click out the
border right click format comment Colors and Lines tab click the drop
down under Fill Color: select Fill Effects select Picture tab click on
Select Picture button select any picture you want click Insert Ok OK

Evertime you your mouse over the comment the picture will pop up

"oxicottin" wrote:

Is there any way I can run my mouse over a section and have a pop up appear
"say a small picture" for a few seconds and then close? Im am not good at
macros so if so can you explain in steps?

Thanks!


--

Dave Peterson


drmikec

mouse over pop up
 
Sorry, a little too quick on the Post button. How does Microsoft do the
little info box on their canned templates? Are they not comments? There are
no red triangles in those fields. Thanks.

"drmikec" wrote:



"Dave Peterson" wrote:

The red indicator indicates that there is a comment in that cell.

You can use:
tools|Options|View tab|Comment section

to hide the comment, to show the indicator only (the comment will appear when
you mouse over the cell) or to show both the indicator and the comment.

You'll notice that there isn't an option to hide the comment indicator, but
still allow the comment to appear.

oxicottin wrote:

Thanks I now I know how to do this but even by adding my picture to a comment
box there still is that little triange in the corner. How do you get rid of
it? Thanks for your reply!!!

"Teethless mama" wrote:

Insert Comment Back spaces to clear inside the comment click out the
border right click format comment Colors and Lines tab click the drop
down under Fill Color: select Fill Effects select Picture tab click on
Select Picture button select any picture you want click Insert Ok OK

Evertime you your mouse over the comment the picture will pop up

"oxicottin" wrote:

Is there any way I can run my mouse over a section and have a pop up appear
"say a small picture" for a few seconds and then close? Im am not good at
macros so if so can you explain in steps?

Thanks!


--

Dave Peterson


Dave Peterson

mouse over pop up
 
Are there green triangles on the left side?

Maybe you're seeing the error/warning messages from Tools|Options|Error
Checking.

drmikec wrote:

Sorry, a little too quick on the Post button. How does Microsoft do the
little info box on their canned templates? Are they not comments? There are
no red triangles in those fields. Thanks.

"drmikec" wrote:



"Dave Peterson" wrote:

The red indicator indicates that there is a comment in that cell.

You can use:
tools|Options|View tab|Comment section

to hide the comment, to show the indicator only (the comment will appear when
you mouse over the cell) or to show both the indicator and the comment.

You'll notice that there isn't an option to hide the comment indicator, but
still allow the comment to appear.

oxicottin wrote:

Thanks I now I know how to do this but even by adding my picture to a comment
box there still is that little triange in the corner. How do you get rid of
it? Thanks for your reply!!!

"Teethless mama" wrote:

Insert Comment Back spaces to clear inside the comment click out the
border right click format comment Colors and Lines tab click the drop
down under Fill Color: select Fill Effects select Picture tab click on
Select Picture button select any picture you want click Insert Ok OK

Evertime you your mouse over the comment the picture will pop up

"oxicottin" wrote:

Is there any way I can run my mouse over a section and have a pop up appear
"say a small picture" for a few seconds and then close? Im am not good at
macros so if so can you explain in steps?

Thanks!

--

Dave Peterson


--

Dave Peterson

Gord Dibben

mouse over pop up
 
Those are most likely Data Validation messages.

Select a cell with the pop-up and check for DV.


Gord Dibben MS Excel MVP

On Wed, 30 May 2007 19:26:01 -0700, drmikec
wrote:

Sorry, a little too quick on the Post button. How does Microsoft do the
little info box on their canned templates? Are they not comments? There are
no red triangles in those fields. Thanks.

"drmikec" wrote:



"Dave Peterson" wrote:

The red indicator indicates that there is a comment in that cell.

You can use:
tools|Options|View tab|Comment section

to hide the comment, to show the indicator only (the comment will appear when
you mouse over the cell) or to show both the indicator and the comment.

You'll notice that there isn't an option to hide the comment indicator, but
still allow the comment to appear.

oxicottin wrote:

Thanks I now I know how to do this but even by adding my picture to a comment
box there still is that little triange in the corner. How do you get rid of
it? Thanks for your reply!!!

"Teethless mama" wrote:

Insert Comment Back spaces to clear inside the comment click out the
border right click format comment Colors and Lines tab click the drop
down under Fill Color: select Fill Effects select Picture tab click on
Select Picture button select any picture you want click Insert Ok OK

Evertime you your mouse over the comment the picture will pop up

"oxicottin" wrote:

Is there any way I can run my mouse over a section and have a pop up appear
"say a small picture" for a few seconds and then close? Im am not good at
macros so if so can you explain in steps?

Thanks!

--

Dave Peterson



drmikec

mouse over pop up
 
You nailed it, Gord! Thanks. It's been bugging me for a while. Now I can
get rid of all those clunky comments when I just want to add instructions for
a field!
Best regards,

Mike

"Gord Dibben" wrote:

Those are most likely Data Validation messages.

Select a cell with the pop-up and check for DV.


Gord Dibben MS Excel MVP

On Wed, 30 May 2007 19:26:01 -0700, drmikec
wrote:

Sorry, a little too quick on the Post button. How does Microsoft do the
little info box on their canned templates? Are they not comments? There are
no red triangles in those fields. Thanks.

"drmikec" wrote:



"Dave Peterson" wrote:

The red indicator indicates that there is a comment in that cell.

You can use:
tools|Options|View tab|Comment section

to hide the comment, to show the indicator only (the comment will appear when
you mouse over the cell) or to show both the indicator and the comment.

You'll notice that there isn't an option to hide the comment indicator, but
still allow the comment to appear.

oxicottin wrote:

Thanks I now I know how to do this but even by adding my picture to a comment
box there still is that little triange in the corner. How do you get rid of
it? Thanks for your reply!!!

"Teethless mama" wrote:

Insert Comment Back spaces to clear inside the comment click out the
border right click format comment Colors and Lines tab click the drop
down under Fill Color: select Fill Effects select Picture tab click on
Select Picture button select any picture you want click Insert Ok OK

Evertime you your mouse over the comment the picture will pop up

"oxicottin" wrote:

Is there any way I can run my mouse over a section and have a pop up appear
"say a small picture" for a few seconds and then close? Im am not good at
macros so if so can you explain in steps?

Thanks!

--

Dave Peterson





All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com