If the value of a cell is not null, show a pop up message or a reminder text in another...

Hi all,

I have a form in Excel, once the user starts filling in the form, entering a text in a cell, I want to show a a pop up message or a reminder text in the next cell. Just to remind them not to forget to do some tasks. How this can be achieved?
I know that I can use/ data>Data Validation> Input Message.. But, it is not going to help me, because the criteria to use this is only if the cell is selected. I want the pop up message if the value of the cell if not null.


Thanks,

Ninajigar, when you say "filling in a form" are you referring to a User Form, or just filling in Cells in a spreadsheet?

Originally Posted by Gregb11

Ninajigar, when you say "filling in a form" are you referring to a User Form, or just filling in Cells in a spreadsheet?

Filling in cells in a spreadsheet.

Originally Posted by noboffinme

Hi Ninajigar,
If you are familiar with VBA code, you could add a messagebox to this Forms Text Box to say what you want.
If you want help with this, pls post your file.

excel_form_fill_in_popmesg.png I got a screen shot of the spreadsheet ... Thx

You could probably do an "on-change" event macro, but a simple option is to do data validation. On the Name field, create a data validation where the criteria is to Allow "Text Length" less than 1 (meaning if anything is entered into the cell). Then for the error Alert section, give it an "Information" style, with the message you want to give, like, "Please be sure to fill in the section below".

Sounds like you put the message in the wrong place. Put the message in the "Error Alert" tab, not the "Input Message" tab. Allowing text length of less than 1 says you allow blanks, but after someone types something in, and then hits enter - that's when the message will appear.

Originally Posted by Gregb11

Sounds like you put the message in the wrong place. Put the message in the "Error Alert" tab, not the "Input Message" tab. Allowing text length of less than 1 says you allow blanks, but after someone types something in, and then hits enter - that's when the message will appear.

Thanks a lot! it workds perfectly fine. However, users with different roles will see different number of fileds; how can I make sure that everytime a new filed is added, this function will work? is there a vb program for it? if yes, can you please posted here....

There are new Name Fields added? How are they added? If you copy/paste the name field, it will carry over the same functionality (data validation).

Please have a look at the attached image:
excel_form_fill_in_popmesg.png
If there is any value in column H (third column), I don't want the popup window to be shown when the users type in something in the second column. How this can be achieved?
Thanks,

To do this, do the following:
Go to "Data Validation" like you did before, only this time, under the settings tab, under "Allow:", select "Custom", and in the formula field enter:
=SUM(NOT(ISBLANK(H:H))*1)>0