VBA Loops

Hi there

I was wondering if anyone can help me with loops. I'm just learning this and am working on an exercise for class.

Basically, the problem states that an aluminum structure is dipped in acid and loses 1% in weight each time it is dipped. The overall weight cannot be under 10 lbs so I would have to loop until the weight is about 10 lbs. Then find final weight depending on what the user has inputted prior to the structure being dipped (original weight).

my code so far:

Please Login or Register  to view this content.

I'm not really sure about what to do to make it work.
Any help is greatly appreciated.

Hi randomperson15
first change the dims to doubles to cope with the numbers you are working with
long reserve memory for -2,147,483,648 to 2,147,483,647 where
double is 4.94065645841247E-324 to 1.79769313486232E308
one percent of some thing will be a decimal

with the loop you need to keep calculating and reducing j but one percent

Please Login or Register  to view this content.

the first place to find examples of code is with the VBA help. just highlight the "Do" in the code and press "F1".

Thank you so much, Pike. Your format is way better than mine as it isn't all over the place with more variables.