LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default "change" event for validation/pick lists

Hi, I understand there is a "Worksheet_Change()" event that kicks i
once a cell's value has been changed. I have a cell where to there i
a pick list to pick a value, but once this is done the Change() even
doesn't kick in. Nor, does the calculate event. (I can't get th
calculate event to work for anything, but thats besides the point :)

Anyway, does anyone know how to access this. Essentially, i'd like t
update all the other cells that reference this pick list cell when th
pick list cell has been modified. The way I was going to do it was us
the event, and basically do a Worksheets("Sheet1").Calculate whic
would update those values as well as others.

I'm using Excel 97 :< Any help would be appreciated. Thanks

--
Message posted from http://www.ExcelForum.com

 
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
Validation ?:Accepting both Numbers AND specific letters("N","n"," Antonio Excel Discussion (Misc queries) 2 April 22nd 08 05:07 PM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
Users overwriting cells with Validation set to "Lists" Mack Neff[_2_] Excel Discussion (Misc queries) 3 June 25th 07 05:39 PM
"Dragging Chart Markers to Change Data" Event Andrei Excel Programming 1 August 12th 03 02:02 AM
Is there a "cell change" event? Mark Smith Excel Programming 1 July 11th 03 01:52 PM


All times are GMT +1. The time now is 08:11 AM.

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"