popup or dropdown selectabel list?

[buckau]

Hi I have a work sheet that I update daily and in the comments column I am consistently entering the same comment I would like to have a popup or dropdown window in this column were I can select an existing comment or a comment from a predefined list and enter it in to the comments cell, I also need to be able to enter a new comment if needed.
Can any one explain to me how to do this?

 

[HiTechCoach]

Have you tried used a form?

See:

How to add data to a ComboBox control or a ListBox control in Excel or Word

 

[buckau]

thanks for that but i have not got to the stage of adding a form yet! and at this stage i donot know how to add a form to Excel 2000.
i have been using access 2000 for about 3 years and am able to creat combos and dropdowns in assecc ok i have never tryed to do it in Excell befor!

 

[qafself]

Use data validation to create a list

http://www.contextures.com/xlDataVal01.html

is a fantastic place to start