LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default problem :Onclick event occurs after a Setfocus

hi there ,

On a userform , I have several textboxes and a listbox in a frame.
The listbox is the last object in the tabstop order in that frame.
On top of the form there is a commandbutton .

Each time when I push the ENTER key in the frame the tabstop moves to the
next object until it reaches the listbox.
To move to the next object ( the commandbutton ) from the listbox , I put
some code behind the listbox.Keydown event i found on the net.

Private Sub LstType_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal
Shift As Integer)
If KeyCode = 13 Then
Me.Commandbutton1.SetFocus
End If
End Sub

This works fine to move to the commandbutton , but when it gets the focus it
runs the On_click code.
I just want to get the focus on the commandbutton , not to execute the code
behind the button.

Is there a solution for this.

Kind regards for helping me .
Mario


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change event occurs Otto Moehrbach Excel Programming 2 December 2nd 05 04:53 PM
OnClick event lilika Excel Programming 2 February 22nd 05 05:34 PM
dynamic hyperlink or onclick event Tasha Excel Programming 2 February 16th 05 01:57 PM
onclick event for cell ties Excel Programming 4 July 20th 04 12:09 PM
event which occurs when a TextBox receives focus Mikhail Excel Programming 2 October 7th 03 02:27 PM


All times are GMT +1. The time now is 07:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"