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

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
 
S

Shane Devenshire

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
 
M

MichaelRLanier

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

Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automically add information from one text box to another 0
Non-macro method (like conditional formatting) to insert text in cell? 7
Referring to columns in the text of a cell 2
inserting text from a combo box to a text box 1
Sumif based on text within a sentence in a cell 2
counting commas within a string 3
finding numbers within text 14
counting the number of commas within a text string 2

Top