Hi,

I would like to change the size of the message box so that words don't wrap.

If this isn't an option, can someone guide me to VBA code that will display
a message box that I can resize when I click in a cell?

I don't want to use comments, because I don't want to have to point to the
cell - I need the message to display when the cell is active.
--
Thanks!

Dee

You can't change the size of a data validation input message, manually
or programmatically. You could add a comment to the cell, and use event
code to display that comment when the cell is selected.

dee wrote:
Hi,

I would like to change the size of the message box so that words don't wrap.

If this isn't an option, can someone guide me to VBA code that will display
a message box that I can resize when I click in a cell?

I don't want to use comments, because I don't want to have to point to the
cell - I need the message to display when the cell is active.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Hi Debra,

Thanks again for this response. That is exactly what I wish to do.

Do you know where I can find a "snippet" of code in order to do this? I am
hoping that it is something I can run for an entire workbook or at least
worksheet.

Thank you.
--
Thanks!

Dee


"Debra Dalgleish" wrote:

You can't change the size of a data validation input message, manually
or programmatically. You could add a comment to the cell, and use event
code to display that comment when the cell is selected.

dee wrote:
Hi,

I would like to change the size of the message box so that words don't wrap.

If this isn't an option, can someone guide me to VBA code that will display
a message box that I can resize when I click in a cell?

I don't want to use comments, because I don't want to have to point to the
cell - I need the message to display when the cell is active.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

You could record a macro as you insert a comment with the text that you
want, then modify the recorded code.

There are sample macros here, that might help you, including one that
shows a comment when a cell is selected:

http://www.contextures.com/xlcomments03.html


dee wrote:
Hi Debra,

Thanks again for this response. That is exactly what I wish to do.

Do you know where I can find a "snippet" of code in order to do this? I am
hoping that it is something I can run for an entire workbook or at least
worksheet.

Thank you.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html