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.

Hi!

It might be a data validation input message.

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

Is the message there?

Biff

"PaulMurphy" wrote in message
...
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:

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

Rob

"Biff" wrote:

Hi!

It might be a data validation input message.

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

Is the message there?

Biff

"PaulMurphy" wrote in message
...
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.

You're welcome!

Biff

"PaulMurphy" wrote in message
...
Biff:

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

Rob

"Biff" wrote:

Hi!

It might be a data validation input message.

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

Is the message there?

Biff

"PaulMurphy" wrote in message
...
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.

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

"Biff" wrote:

You're welcome!

Biff

"PaulMurphy" wrote in message
...
Biff:

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

Rob

"Biff" wrote:

Hi!

It might be a data validation input message.

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

Is the message there?

Biff

"PaulMurphy" wrote in message
...
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.

David wrote:
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"