View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jean-Yves[_2_] Jean-Yves[_2_] is offline
external usenet poster
 
Posts: 253
Default Keeping focus on a txtbox

Hi Tim,

Give all other control the property "TabStop" to false for text boxes or
TakeFocusOnClick for button, etc to false
That way only your Text1 can get the focus
Regards
Jean-Yves

"Tim" wrote in message
ups.com...
I have txt1 on a form which should always get focus after any other
control is used. I have a spin button which I use to change the value
in txt2. When I click the spin button, if I use txt1.setfocus at the
end of the spinup and spindown events, txt1 only receives the focus
every second click. Why is this? The only way I have found to keep
the focus on txt1 is by placing the txt1.setfocus in the 'enter' event,
but then the spin button has no effect. How can I keep the focus on
txt1 and still allow the spin button to have an effect?