Updating of cell linked to drop-down list

[zalcjm]

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

[Tom Ogilvy]

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
>
>