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

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