Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validation ?:Accepting both Numbers AND specific letters("N","n"," | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Users overwriting cells with Validation set to "Lists" | Excel Discussion (Misc queries) | |||
"Dragging Chart Markers to Change Data" Event | Excel Programming | |||
Is there a "cell change" event? | Excel Programming |