Thread: Userforms
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ernst Guckel[_4_] Ernst Guckel[_4_] is offline
external usenet poster
 
Posts: 34
Default Userforms

Hello,

I have a form with two frames on it. Each frame has a few controls. In
the exit event of the controls I reformat the text to correct user entry
errors. The problem I have is that when a user tabs out of the last control
on a form the exit event does not fire until the user tabs back into the
frame. Is there a way around this? And second... In one exit event I verify
the integrety of the data and if incorect I set the focus back to the control
but this does not seem to work. Can you not set focus in the exit event?

Thanks,
Ernst.