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.

Is this a userform that contains the textbox?

If it is, maybe it's time to use a combobox where you can choose the value from
the list.

enyaw wrote:

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.

--

Dave Peterson