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.

Chris,

I was looking at your request. What do you intened to do with the inf
once found? It problely would be easiser to use a userform for the fin
function. Ive started a pgm using the userform. So if you let me kno
what you want to happen I'll finish it and send it to you.

Charle

--
Message posted from http://www.ExcelForum.com

Thanks Charles for your reply.

Fortunately, a couple of other kind people like yourself have solved m
problem.

Kind regards,

Chris :

--
Message posted from http://www.ExcelForum.com