[quote]
On 2002-03-13 12:13, chunky wrote:
can someone pls help me how to write in a pickin list box thankx
[Hi,

If you pick a blank area on your spreadsheet say column dd and then list then values you want to appear in your list box. Go to one of the cells that you want the data to appear in and choose data/validation/ choose list and then in souurce enter details from source list ie $dd$1:$dd$6 This will populate the fielda as required.

to ensure that this happen in all field required highlight the cells and press enter. the office assistant will ask if you want the validation to apply to all cells enter yes.


Good luck]