Hi,

You do not need Visual Basic for Applications for this. You can use Data Validation and Named Ranges. This link will give you some good examples ...

http://www.mrexcel.com/board2/viewtopic.php?t=126822