ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Loop through a range, allow user input during... (https://www.excelbanter.com/excel-programming/379922-loop-through-range-allow-user-input-during.html)

AD108

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.




All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com