[Request] - Convert Excel formula to VB6 Code

[longwest]

I have two suggestions:
1. Try and embed the excel sheet and continue normal functioning of the application
2. Split the if statements up for me an i'll lend you a hand.
Because of the format, I have no idea whats going on in 2 and especially 3. I may have an example at school that was a bar-code validation program I could send you if your able to learn from source code (some are, most aren't).

Thank you for the suggestions and the bar code validation program source code, I originally plan to for help on stackoverflow, lucky to found this share.