Hi,
I need a message box, where i need to type in the numbers.
I have item codes in column A
123456
456789
147896
158496
123456
when I type in the number in message box for example " 123456" if the numbers are available in that column I need those numbers to be colored, so as and when I type the numbers if the numbers are available I need the numbers to get colored else a message saying number not found.
Regards,
Ron
I need a message box, where i need to type in the numbers.
I have item codes in column A
123456
456789
147896
158496
123456
when I type in the number in message box for example " 123456" if the numbers are available in that column I need those numbers to be colored, so as and when I type the numbers if the numbers are available I need the numbers to get colored else a message saying number not found.
Regards,
Ron