View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Todd[_12_] Todd[_12_] is offline
external usenet poster
 
Posts: 1
Default Data Validation not working (with a Worksheet_SelectionChange event)

Hi folks,

I am using Excel 2003 SP2. I am doing some data validation and it
_was_ working fine. Then I added a ActiveX calendar object to the
sheet and my validation funtionality changed.

I have a feeling that the problem lies in the fact that I now have a
SelectionChange event, due to the addition of the calendar object. I
no longer get the drop down arrow but when I enter an invalid entry, I
do get an error.

The validation functionality (including the drop down) works fine on
other sheets in the same workbook.

HELP !!!

-Todd