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

[QDZF]

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?

[crazybass2]

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?