Data validation input message

[DT]

Can anyone please offer any advice? ..... I am using data validation on a
worksheet and would like to resize the message box that appears when the
cell is selected. Can this be done in Excel either using an option or by
using some VBA?

Many thanks,

DT.

 

[Vasant Nanavati]

I'm not sure what message appears when the cell is *selected*. Are you
referring to the error message that is triggered by an invalid entry? If so,
AFAIK, there is no way to modify it.

 

[DT]

No, this is the message tip that appears when the cell is selected, not when
invalid data has been entered.

I seem to remember reading in the past that it can be resized using VBA code
but can't for the life of me remember where I read this.

 

[Dave Peterson]

You sure you didn't read about resizing comments?

I don't think I've seen a way to change that data|validation message.

 

[RagDyeR]

Maybe you're talking about the actual "Drop Down Box" in data validation
that displays when you select the cell.

If that's the case, the work around to increase the size is to increase the
zoom display, make the choice, then return the zoom to the previous setting.

This can be more easily accomplished using code.

Check out Debra Dalgleish's web site that has a procedure for this:

http://www.contextures.com/xlDataVal08.html#Larger
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


No, this is the message tip that appears when the cell is selected, not when
invalid data has been entered.

I seem to remember reading in the past that it can be resized using VBA code
but can't for the life of me remember where I read this.

 

[DT]

I am familiar with resizing comments in Excel but you cannot do the same
with Data Validation can you?

The question I'm asking is whether you can change the size of the message
that appears when the cell (in which Data Validation has been set) is
selected??!!?

Thanks,

DT.

 

[DT]

No ... it's the actual message which appears when the cell is selected that
has Data Validation set.

DT.

 

[DT]

When I say the size of the message, I mean the box which appears that looks
like a tool tip.

DT.

I am familiar with resizing comments in Excel but you cannot do the same
with Data Validation can you?

The question I'm asking is whether you can change the size of the message
that appears when the cell (in which Data Validation has been set) is
selected??!!?

Thanks,

DT.

You sure you didn't read about resizing comments?

I don't think I've seen a way to change that data|validation message.

not

when

VBA

code

entry?

If

validation

on

when

 

[Dave Peterson]

gotcha. It's the message that pops up when you select the cell--not the error
message, not a comment.

I don't know a way.

When I say the size of the message, I mean the box which appears that looks
like a tool tip.

DT.