It would have been easier to set up as the built-in Excel .Dropdown object -
the code would have been easier, in my opinion. But what you need to do with
your combo is to set the LinkedCell property to be the address of the cell
you want.

put this line in the code where you are setting the combo's properties:
combo.LinkedCell = Cells(13, 5).Address
Then I think it will behave the way you want.
--
- K Dales


"Amoni" wrote:


Hi !
Yes Im trying to get the selected value to display in cell(13,5) just to
notify if the action is correct.
Didnt understand what u meant with "to add that
and by using a forms combobox you would need to programatically add the code.
"