Data Validation not working (with a Worksheet_SelectionChange event)

[Todd]

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

 

[Norman Jones]

Hi Todd,

I added various data validation to a sheet and inserted a calendar control.
I then added a Selection_Change procedure to show and dismiss the control.
This had no discernable impact on the DV functionality and I was unable to
reproduce your problem.

If you add a calendar control and your event code to one of the other sheets
where DV is working correctly, are you able to reproduce the problem?