need help with list box?

[Danny]

Hi

I have a huge table of about 20000 records. how can I restrict entry for a
few columns.
I am new to excel programming.

For example. I have a list of colors (red, green, blue) that I want to go
under the Color column. how can I allow the user to click on a pulldown or
list box similar to ms access for each cell.

thanks in advance.

 

[Frank Kabel]

Hi
you could use
'Data - Validation'. See:
http://www.contextures.com/xlDataVal01.html

 

[Danny]

Thanks soo much for your help.
I posted another, maybe you can help.