I am using a combo box to fill in some standard information and I know how
they should appear in the cell, so I can copy and paste to a new cell. But If
my list has two cell how can I get that the destiby cells appears one of the
cells info only.

Example

A1 B1
Urban 1
Rural 2
I want to choose Urban from the combo box, but the information to be stored
in the destiny cell should be 1.
I know how to do it for Urban, that is the destiny will show Urban but I
want to get 1.


Please help

Alberto Vargas