Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run command when hitting ENTER on list box item
Couldn't you just use either/both of these:
Option Explicit Private Sub ListBox1_Click() MsgBox "Click" End Sub Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) MsgBox "dclick" End Sub "Mr. Smith" wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
value changes after hitting Tab or Enter button | Excel Discussion (Misc queries) | |||
Cell changes to a formula after hitting ENTER | Excel Discussion (Misc queries) | |||
numbers appear different after hitting enter | New Users to Excel | |||
What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
Insert new row after hitting enter | Excel Programming |