View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
crazybass2 crazybass2 is offline
external usenet poster
 
Posts: 167
Default 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?