View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default Looping through valid inputs (VBA)

DS's solution is for those who don't trust the system.
Bob Phillips is for those with faith in something as well established as For
Next loops to actually work.

You could combine the two in your MsgBox output to compare the values
computed by each method.

"DesireeStar" wrote:

Heh, yeah. I mean to produce an actual number as to how many times it
looped total.

Ie:
MsgBox "This looped " + loopCountTotal + " times"