Visual Basic Gurus! Simple question...

[novon]

Someone decides to invest $1000 per year at 7% annual return, how long before she has $1000000?

I need a simple prog that calcs this and prints the years it took on screen...

anyone?

I'm brand new to programming....

here is what i have so far, and it's not working:

For t = 0 To 1000#
a = a + 1000
a = a * 1.07
years = years + 1
If a = 1000000 Then GoTo done Else
Next t

done:
Print years


Thanks

 

[yakko]

Don't know. How long?

 

[Poontos]

E=MC2

 

[Angrymarshmello]

a might not ever hit 1000000, so that might be why it doesn't work. Try a >= 1000000