software

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 Datagt;Validation
Select the Input Message tab (if it doesn't automatically open)

Is the message there?

Biff

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

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

Rob

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; It might be a data validation input message.
gt;
gt; Select the cell in question.
gt; Goto Datagt;Validation
gt; Select the Input Message tab (if it doesn't automatically open)
gt;
gt; Is the message there?
gt;
gt; Biff
gt;
gt; quot;PaulMurphyquot; gt; wrote in message
gt; ...
gt; gt; My boss gave me a spreadsheet (that he did not create) where a text box
gt; gt; appears when you click in or are residing in a cell, and disappears when
gt; gt; you
gt; gt; leave the cell. Format-wise the box looks like a comment box, but is not
gt; gt; attached to a cell (with a connecting line) nor is it edit-able. Within
gt; gt; the
gt; gt; cell itself, the formula line appears blank and you can even type
gt; gt; something
gt; gt; in and it doesn't change the text/comment box. Now he wants me to
gt; gt; re-create
gt; gt; that commentary function in a new spreadsheet. I want to dazzle him with
gt; gt; my
gt; gt; Excel knowledge...any ideas on what I am looking at and how to do it in a
gt; gt; new
gt; gt; spreadsheet? Thanks.
gt;
gt;
gt;

You're welcome!

Biff

quot;PaulMurphyquot; gt; wrote in message
...
gt; Biff:
gt;
gt; It didn't work....that is until I unprotected the worksheet, then your
gt; suggestion worked. Thanks so much!
gt;
gt; Rob
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Hi!
gt;gt;
gt;gt; It might be a data validation input message.
gt;gt;
gt;gt; Select the cell in question.
gt;gt; Goto Datagt;Validation
gt;gt; Select the Input Message tab (if it doesn't automatically open)
gt;gt;
gt;gt; Is the message there?
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;PaulMurphyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; My boss gave me a spreadsheet (that he did not create) where a text box
gt;gt; gt; appears when you click in or are residing in a cell, and disappears
gt;gt; gt; when
gt;gt; gt; you
gt;gt; gt; leave the cell. Format-wise the box looks like a comment box, but is
gt;gt; gt; not
gt;gt; gt; attached to a cell (with a connecting line) nor is it edit-able. Within
gt;gt; gt; the
gt;gt; gt; cell itself, the formula line appears blank and you can even type
gt;gt; gt; something
gt;gt; gt; in and it doesn't change the text/comment box. Now he wants me to
gt;gt; gt; re-create
gt;gt; gt; that commentary function in a new spreadsheet. I want to dazzle him
gt;gt; gt; with
gt;gt; gt; my
gt;gt; gt; Excel knowledge...any ideas on what I am looking at and how to do it in
gt;gt; gt; a
gt;gt; gt; new
gt;gt; gt; spreadsheet? Thanks.
gt;gt;
gt;gt;
gt;gt;
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

quot;Biffquot; wrote:

gt; You're welcome!
gt;
gt; Biff
gt;
gt; quot;PaulMurphyquot; gt; wrote in message
gt; ...
gt; gt; Biff:
gt; gt;
gt; gt; It didn't work....that is until I unprotected the worksheet, then your
gt; gt; suggestion worked. Thanks so much!
gt; gt;
gt; gt; Rob
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt;gt; Hi!
gt; gt;gt;
gt; gt;gt; It might be a data validation input message.
gt; gt;gt;
gt; gt;gt; Select the cell in question.
gt; gt;gt; Goto Datagt;Validation
gt; gt;gt; Select the Input Message tab (if it doesn't automatically open)
gt; gt;gt;
gt; gt;gt; Is the message there?
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;PaulMurphyquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; My boss gave me a spreadsheet (that he did not create) where a text box
gt; gt;gt; gt; appears when you click in or are residing in a cell, and disappears
gt; gt;gt; gt; when
gt; gt;gt; gt; you
gt; gt;gt; gt; leave the cell. Format-wise the box looks like a comment box, but is
gt; gt;gt; gt; not
gt; gt;gt; gt; attached to a cell (with a connecting line) nor is it edit-able. Within
gt; gt;gt; gt; the
gt; gt;gt; gt; cell itself, the formula line appears blank and you can even type
gt; gt;gt; gt; something
gt; gt;gt; gt; in and it doesn't change the text/comment box. Now he wants me to
gt; gt;gt; gt; re-create
gt; gt;gt; gt; that commentary function in a new spreadsheet. I want to dazzle him
gt; gt;gt; gt; with
gt; gt;gt; gt; my
gt; gt;gt; gt; Excel knowledge...any ideas on what I am looking at and how to do it in
gt; gt;gt; gt; a
gt; gt;gt; gt; new
gt; gt;gt; gt; spreadsheet? Thanks.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

David wrote:
gt; Good day!
gt;
gt; Need some help...
gt;
gt; I need to add a little window popup to my .xls after people open it...
gt;
gt; So that they first thing they see when they open the sheet is this
gt; window...
gt;
gt; How do I do that?
Follow the instructions here
www.ozgrid.com/VBA/ExcelWorkbookEvents.htm to get to the workbook
events tab.
Then in the workbook_open event put msgbox quot;message to pop upquot;
thanks a lot!

Have a nice day,

David

quot;Paul Lautmanquot; wrote:

gt; David wrote:
gt; gt; Good day!
gt; gt;
gt; gt; Need some help...
gt; gt;
gt; gt; I need to add a little window popup to my .xls after people open it...
gt; gt;
gt; gt; So that they first thing they see when they open the sheet is this
gt; gt; window...
gt; gt;
gt; gt; How do I do that?
gt; Follow the instructions here
gt; www.ozgrid.com/VBA/ExcelWorkbookEvents.htm to get to the workbook
gt; events tab.
gt; Then in the workbook_open event put msgbox quot;message to pop upquot;
gt;
gt;
gt;