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