Note that the combo box, the input range, and linked cell can be on 3
separate sheets, providing flexibility in setting it up to suit what you
have in mind.

For example:

In the Control tab, with the settings:
Input range: Sheet1!$A$1:$A$20
Cell link: Sheet3!$B$1

The combo box itself could be somewhere in Sheet2, reading from the source
range in Sheet1!$A$1:$A$20, and outputting the droplist selections in
Sheet3!$B$1 (the linked cell). Named ranges can also be used for the input
range and the cell link.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----