Thread: RefEdits
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JT JT is offline
external usenet poster
 
Posts: 234
Default RefEdits

I have a macro that displays a form with 3 RefEdits. When the user is
finished, they click "ok" and the macro continues. One of the first thing I
do is check to ensure if all 3 RefEdits have data in it. If they don't the
macro sets the focus on the RefEdit that is empty.

I want the form to stay on the screen until all 3 RefEdits are completed.
It stays open and I can enter data but when I push "ok" the second time, the
form goes away and the macro appears to complete but it isnt finishing the
remaining steps.

Any suggestions? Thanks
--
JT