How do I get data validation message to appear using a macro?
 

I'm writing a macro and I want to add an information window using data
validation. My macro creates the message in the cell and when I manually
click on it and add unauthorized data, it displays the window when I tab off
the field. I enter the same data through a macro and then select a new cell,
but the display window does not apear. How can I get the window to show?

How do I get data validation message to appear using a macro?
 

Would you mind posting your code? It is difficult to debug without seeing
what you have.



"QDZF" wrote:

I'm writing a macro and I want to add an information window using data
validation. My macro creates the message in the cell and when I manually
click on it and add unauthorized data, it displays the window when I tab off
the field. I enter the same data through a macro and then select a new cell,
but the display window does not apear. How can I get the window to show?