Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"change" event for validation/pick lists
The change event doesn't fire in Data Validation in Excel 97. Does in 2000+,
but not 97. What you have to do is refer/link to that DV cell, and then trap the calculate event. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Fherrera " wrote in message ... Hi, I understand there is a "Worksheet_Change()" event that kicks in once a cell's value has been changed. I have a cell where to there is a pick list to pick a value, but once this is done the Change() event doesn't kick in. Nor, does the calculate event. (I can't get the calculate event to work for anything, but thats besides the point :) Anyway, does anyone know how to access this. Essentially, i'd like to update all the other cells that reference this pick list cell when the pick list cell has been modified. The way I was going to do it was use the event, and basically do a Worksheets("Sheet1").Calculate which 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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"change" event for validation/pick lists
Alright. No idea how to answer my own question but I did find
different much much easier way of doing it. (you ever notice that whe you try to find an answer to a problem you usually make it much muc harder than it has to be) For some reason my re-calculate values in the Tools-Options menu wa set to manual... now it updates it (I was wondering too why it neve updated when i changed a cell reference) Anyway it's good now. Thanks -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |