hi guys, I have a userform with some dropdown boxes for a user to choose a Month no, which when chosen data is copied from one sheet to another which all works fine, I was wondering if anyone had any code that I could use, so if a user chose say month 10, but data in the records sheet does not exist for that month then a message box appears asking the user to choose a different month number and the code is stopped, Month numbers are stored in column Z on the records sheet.

many thank

scouse13