Hello,

Could someone please help me with the following:

I wish to create a macro that does the following:

Asks via InputBoxes for user input.

1. One InputBox asks for a Stockcode (a nine digit number)
2. The other InputBox asks for a Recommend Finalisation As (which will be
either:WOC or BOC)

The Stockcode needs to be validated to ensure that it is a number and has 9
digits.

I have formatted the Stockcode column (column E) as Text, because many of
our Stockcodes are preceded by zeros.

Then a double-Lookup function to lookup the Stockcode in column E and the
Recommend Finalisation As in column F.

If there is a match, then to list it on a MessageBox.

I need it to lookup the entire spreadsheet (named SA Register) because there
may be more than one instance where a match will be found.

Any help would be greatly appreciated,

Kind regards,

Chris.