View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AD108 AD108 is offline
external usenet poster
 
Posts: 21
Default Loop through a range, allow user input during...

Hello,

I want to loop through each cell in range, display a userform if a
certain condition is met, and then allow the user to enter a value in a
worksheet before the loop continues. Can I do this with a modeless
userform?
My previous attempts have failed, because as my userform is modeless,
the loop goes straight to the end of the range, and only displays a userform
for the last instance of the true condition.