Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 300
Default In what version was the change event on a data validation list fixed?

I know that in xl 97 getting a change event to work for a change in a data
validation list was downright flaky. I know that it works fine in xl 2002.
But what is the status of xl 2000? We are buying a company that uses 2000.
My programs expect this to work. There are probably other features I use,
which may not work in 2000. Is there a chart somewhere of 2000 and 2002
differences?

Don <www.donwiss.com (e-mail link at home page bottom).
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default In what version was the change event on a data validation list fix

the data validation trigger works in xl2000.

I am not aware of any such list. You might look at what's new in vba help
for xl2002. The protection options for a worksheet were expanded.

--
Regards,
Tom Ogilvy


"Don Wiss" wrote:

I know that in xl 97 getting a change event to work for a change in a data
validation list was downright flaky. I know that it works fine in xl 2002.
But what is the status of xl 2000? We are buying a company that uses 2000.
My programs expect this to work. There are probably other features I use,
which may not work in 2000. Is there a chart somewhere of 2000 and 2002
differences?

Don <www.donwiss.com (e-mail link at home page bottom).

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Worksheet Change Event With Validation List Kris_Wright_77 Excel Programming 5 January 24th 06 05:41 PM
Event Procedure - Data Validation List JEFF Excel Programming 19 July 25th 05 03:35 PM
Change event for data validation listbox Steve Parkinson Excel Programming 4 January 14th 05 02:57 PM
Data Validation & ControlSource & Change event Ocker Excel Programming 4 November 5th 04 03:34 AM
Sheet change event and list validation question Nick Excel Programming 1 October 21st 04 01:20 PM


All times are GMT +1. The time now is 10:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"