For a list box you could use data validation.
Go to: Data Validation...
Select list from the Allow: box
In the Source: box select the range with the data you need for the
user's selection.
Hit OK
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!