Text/Comment Box appears magically

[Guest]

My boss gave me a spreadsheet (that he did not create) where a text box
appears when you click in or are residing in a cell, and disappears when you
leave the cell. Format-wise the box looks like a comment box, but is not
attached to a cell (with a connecting line) nor is it edit-able. Within the
cell itself, the formula line appears blank and you can even type something
in and it doesn't change the text/comment box. Now he wants me to re-create
that commentary function in a new spreadsheet. I want to dazzle him with my
Excel knowledge...any ideas on what I am looking at and how to do it in a new
spreadsheet? Thanks.

 

[Biff]

Hi!

It might be a data validation input message.

Select the cell in question.
Goto Data>Validation
Select the Input Message tab (if it doesn't automatically open)

Is the message there?

Biff

 

[Guest]

Biff:

It didn't work....that is until I unprotected the worksheet, then your
suggestion worked. Thanks so much!

Rob

 

[Biff]

You're welcome!

Biff

Biff:

It didn't work....that is until I unprotected the worksheet, then your
suggestion worked. Thanks so much!

Rob

 

[Guest]

Good day!

Need some help...

I need to add a little window popup to my .xls after people open it...

So that they first thing they see when they open the sheet is this window...

How do I do that?


Thanks!

David

 

[Paul Lautman]

Good day!

Need some help...

I need to add a little window popup to my .xls after people open it...

So that they first thing they see when they open the sheet is this
window...

How do I do that?

Follow the instructions here
http://www.ozgrid.com/VBA/ExcelWorkbookEvents.htm to get to the workbook
events tab.
Then in the workbook_open event put msgbox "message to pop up"

 

[Guest]

thanks a lot!

Have a nice day,

David

Follow the instructions here
http://www.ozgrid.com/VBA/ExcelWorkbookEvents.htm to get to the workbook
events tab.
Then in the workbook_open event put msgbox "message to pop up"