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