Can a string text be inserted within an Error Alert text box?

  • Thread starter Thread starter MichaelRLanier
  • Start date Start date
M

MichaelRLanier

Is there a way to create a string text within Data Validation, Error
Alert text box? If so, I want to use a combination of a sentence with
the returned value of a cell. The Error Alert box might read
something like:

You have 5 days remaining.

5 would be the cell value that would be inserted within the text.
Thanks in advance.

Michael
 
Hi,

Nothing built into Excel to handle this, you might be able to do it with VBA

This site has a lot of stuff on Data Validation, check it out, it might have
something on what you want.

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

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
Thanks for your help. Sorry, but I have no "yes" button for some
reason. Thanks again.

Michael
 
Back
Top