View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
lc lc is offline
external usenet poster
 
Posts: 6
Default Combobox question

What I really want to do is to link each selection with a differenct
cell. For example, if my input range consists of the following
information:

1. a
2. b
3. c
4. d

The cells I want my selection to link to is:

1. C100
2. A20
3. D40
4. F50

When I select "a" from the combo box, it will go to the cell C100.
When I select "b" from the combo box, it will go to cell A20.
etc.

I hope this clarifies my question

Thanks.