While loop help for a newbie!

[Mortada]

Hi,

Trying to cause certain pictures to be pasted on my spreadsheet when the user inputs the criterias.

My intention with the code below check while Cell A20 contains "Beachlands A" then check B20 if > 0 or = 0 then do specific statements. Theres is no error at the moment thanks to 6stringjazzar from excel forum, however, once i execute the macro and cell A20 contains "Beachlands A" it seems like it's checking till judgment day or so.. the spreadsheet also becomes unresponsive and i would have to terminate excel all together.

Please Login or Register  to view this content.

Have I structured the while loop to check infinite times?

I would appreciate some insight on this

Thanks

[stnkynts]

Unless I am missing something I don't understand why you need a loop. It appears to me that you are simply checking the value in two cells. Something like this should work, provided the other parts worked they way you wanted:

Please Login or Register  to view this content.

Note: You may want to specify the worksheet that way you don't run into an activeworksheet problem

[6StringJazzer]

I agree with stnkynts.

Just for the sake of education, yes, you have structured an infinite loop. You are testing for a condition each time through the loop, yet you do nothing inside the loop that could change that condition. So the loop runs either zero times or never stops.

By the way, hitting ALT-F4 is the nuclear option. Most (but not all) of the time, if you have a runaway macro, you can interrupt it by hitting BREAK (maybe ALT-BREAK). My machines all have a PAUSE/BREAK key. This will interrupt the code and put you in debug mode.

[Mortada]

I kinda guessed so.. Thanks for the confirmation 6string! and thanks for the solution stnkynts!
Great forum!