VB code for loop printing based on specific excell cell value.

Submitted by ripon_81 on
Dear All, This is my first post on this forum. I am very new to VB programming.I am trying to get output with VB programming from a excell file based on a specific cell value. In my excell order sheet there will be four column with below information: color Article Reference Quantity Red 31223 R-2134 123 Green 34900 R-3245 100 Blue 98745 R-2314 30 Now I want to get output based on quantity cell value. SO that red should print 123 times, green should print 100 and Blue should print 30 times. Problem is I cant get output based on quantity times value. If any one can help me this, then I would be very grateful to him/her. Thanks again for your help. Best regards Ripon