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

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