When the spreadsheet opens I have a text box popping up. I need to type in a
number into the textbox and then verify that it is a number in the list in
sheet one. If the number is on the list then i need to copy the number onto
sheet 2 but if the number is not on the list then i need a message popping up
to say that it is not a correct number.