Updating of cell linked to drop-down list
Hi, I have a drop-down list that uses a named range as input, and obviousl has a single cell as its output. Suppose the user has selected an item from the current drop-down list and the linked cell contains the index of that item. *My issue is tha if the size of the named range changes (i.e. such that the position o the originally selected item changes within it), the list in th drop-down box updates, but the integer in the linked cell does no update (even with calculation set to Automatic).* Is there a way to force updating of the linked cell associated with drop-down box, without the user having to choose a different item i the list and then go back to the original one? Thanks in advance, Jef -- zalcj ----------------------------------------------------------------------- zalcjm's Profile: http://www.excelforum.com/member.php...fo&userid=3587 View this thread: http://www.excelforum.com/showthread.php?threadid=57047 |
Updating of cell linked to drop-down list
think you would have to use the calculate event to force the changes in the
box. Chip Pearson's page on events if you are not familiar http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "zalcjm" wrote: Hi, I have a drop-down list that uses a named range as input, and obviously has a single cell as its output. Suppose the user has selected an item from the current drop-down list, and the linked cell contains the index of that item. *My issue is that if the size of the named range changes (i.e. such that the position of the originally selected item changes within it), the list in the drop-down box updates, but the integer in the linked cell does not update (even with calculation set to Automatic).* Is there a way to force updating of the linked cell associated with a drop-down box, without the user having to choose a different item in the list and then go back to the original one? Thanks in advance, Jeff -- zalcjm ------------------------------------------------------------------------ zalcjm's Profile: http://www.excelforum.com/member.php...o&userid=35877 View this thread: http://www.excelforum.com/showthread...hreadid=570479 |
All times are GMT +1. The time now is 11:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com