This can be easily accomplished using Excel's built in Data Validation feature.You don't need VBA at all