Message Alert for Missing Serial Number: chhalleng

sir,

Required Message alert as follows

Sr.No Item Code
1 SP2001
2 SP2002
3 SP2003
4 SP2004
5 SP2005
6 SP2006
7 SP2002
8 SP2009 Message Alert saying "You have NOT TYPED SERIAL NUM SP2007 AND SP2008"


I mean when user forget (misses) to type serial numbers ,(series not getting complete), Visual Message alert(Box) should be thrown.

Thanks in advance
AC

Try this:-

Please Login or Register  to view this content.

Regards Mick

Sir,

This doesnot seems to work. looks inapporpiate.

Thanks

Try this on sheet1, it should work unless you run a "Mac".
Regrds Mick

sir,

thanks a lot for reply & valuable time

can I also develop similar solution without using VBA/macro as I am not familiar with VBA programming . I am learning it side by side.

Thanks again

Rgds

Dear MikeG/All users,


Thanks for above solution! But what does this macro return when we leave a blank in between two serial number,

I guess it prints junk value (it is not working when left a blank in series number).Kindly suggest..

Thanks & Rgds
A

Try adding the two lines in Red

Please Login or Register  to view this content.