View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mr. Smith Mr. Smith is offline
external usenet poster
 
Posts: 1
Default Run command when hitting ENTER on list box item

Hi.

I have a listbox with several items. If the users double click on an item, a
detail info form are retrieved for the current item. I want the same thing
to happen when the user click ENTER on a highlighted item in a list box

something like this:

Sub frm_mainList_KeyDown()
If application.onkey = {ENTER} THEN
frm_details.show
End if
End sub


Please clean up my code, somone.

Mr. Smith