MrExcel Publishing
Your One Stop for Excel Tips & Solutions

DoEvents


Posted by Stan on November 22, 2001 9:37 AM

I posted an earlier question re: calling Functions that hasn't elicited any responses. Perhaps I can focus my question a little better. Within the Function I have a Do-Loop

'Some code here

Do
DoEvents
Loop Until txtInput.Text <> ""

'More code here

I am able to process "Some code here" but then when I reach the Do-Loop nothing happens, i.e. the program doesn't loop until an entry is made in the testbox. Any ideas why?

Thanks - Stan


Posted by Ivan F Moala on November 22, 2001 6:14 PM

Stan, your code is doing exactly what you have coded it to do ie.
It will loop until your input text does not = ""
So everthing from your DO until your criteria in
the Loop until will execute BUT nothing else
UNTIL that criteria is met.

Was there somthing you wanted it to do specifically ??

Ivan