Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box filter with autocomplete
hi all,
I have a timesheet entry form that requires employee # to operate. Since employee # is something that is assigned, and not reliably referenced on timecards, the operator will use the name to find the EENUM. To do that, I created a combo box that is called on the "BeforeDoubleClick" command. The data that populates it is 6 columns of info, starting with EENUM, Name, Status... and 3 more columns to help the operator identify the correct one to select. I have set the textcolumn so that it references the 2nd column - the names, and the target cell will be populated with the EENUM when the operator closes the combo box. It all works smashingly. But, I want to tune things up a little more. We have 1000+ employees, so the list that is called up is quite large. I would like the drop down button to be automatic & while the employee is typing a name in, for the list to be filtering on every keystroke. I would also like the combobox to close when the operator hits enter, and not force them to use the mouse and click elsewhere on the screen. Am I just dreaming, or is this indeed possible? Thanks in advance for all you help, Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box filter with autocomplete
look at the match related properties of combobox.
-- Regards, Tom Ogilvy " wrote: hi all, I have a timesheet entry form that requires employee # to operate. Since employee # is something that is assigned, and not reliably referenced on timecards, the operator will use the name to find the EENUM. To do that, I created a combo box that is called on the "BeforeDoubleClick" command. The data that populates it is 6 columns of info, starting with EENUM, Name, Status... and 3 more columns to help the operator identify the correct one to select. I have set the textcolumn so that it references the 2nd column - the names, and the target cell will be populated with the EENUM when the operator closes the combo box. It all works smashingly. But, I want to tune things up a little more. We have 1000+ employees, so the list that is called up is quite large. I would like the drop down button to be automatic & while the employee is typing a name in, for the list to be filtering on every keystroke. I would also like the combobox to close when the operator hits enter, and not force them to use the mouse and click elsewhere on the screen. Am I just dreaming, or is this indeed possible? Thanks in advance for all you help, Dave |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box filter with autocomplete
Hi Tom,
Thanks for your help. I have the autocomplete working - that's not the issue. I've also got the dropdown menu opening automatically, by using: Private Sub TempCombo_Change() TempCombo.DropDown End Sub How do I allow the user to simply hit enter to select and exit the combo box? Dave Tom Ogilvy wrote: look at the match related properties of combobox. -- Regards, Tom Ogilvy " wrote: hi all, I have a timesheet entry form that requires employee # to operate. Since employee # is something that is assigned, and not reliably referenced on timecards, the operator will use the name to find the EENUM. To do that, I created a combo box that is called on the "BeforeDoubleClick" command. The data that populates it is 6 columns of info, starting with EENUM, Name, Status... and 3 more columns to help the operator identify the correct one to select. I have set the textcolumn so that it references the 2nd column - the names, and the target cell will be populated with the EENUM when the operator closes the combo box. It all works smashingly. But, I want to tune things up a little more. We have 1000+ employees, so the list that is called up is quite large. I would like the drop down button to be automatic & while the employee is typing a name in, for the list to be filtering on every keystroke. I would also like the combobox to close when the operator hits enter, and not force them to use the mouse and click elsewhere on the screen. Am I just dreaming, or is this indeed possible? Thanks in advance for all you help, Dave |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box filter with autocomplete
Hi Tom,
Thanks for your help. I have the autocomplete working - that's not the issue. I've also got the dropdown menu opening automatically, by using: Private Sub TempCombo_Change() TempCombo.DropDown End Sub How do I allow the user to simply hit enter to select and exit the combo box? Dave Tom Ogilvy wrote: look at the match related properties of combobox. -- Regards, Tom Ogilvy " wrote: hi all, I have a timesheet entry form that requires employee # to operate. Since employee # is something that is assigned, and not reliably referenced on timecards, the operator will use the name to find the EENUM. To do that, I created a combo box that is called on the "BeforeDoubleClick" command. The data that populates it is 6 columns of info, starting with EENUM, Name, Status... and 3 more columns to help the operator identify the correct one to select. I have set the textcolumn so that it references the 2nd column - the names, and the target cell will be populated with the EENUM when the operator closes the combo box. It all works smashingly. But, I want to tune things up a little more. We have 1000+ employees, so the list that is called up is quite large. I would like the drop down button to be automatic & while the employee is typing a name in, for the list to be filtering on every keystroke. I would also like the combobox to close when the operator hits enter, and not force them to use the mouse and click elsewhere on the screen. Am I just dreaming, or is this indeed possible? Thanks in advance for all you help, Dave |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box filter with autocomplete
It retracts for me when I hit enter. Even when I have your change event in
effect. -- Regards, Tom Ogilvy "davy_gravy" wrote: Hi Tom, Thanks for your help. I have the autocomplete working - that's not the issue. I've also got the dropdown menu opening automatically, by using: Private Sub TempCombo_Change() TempCombo.DropDown End Sub How do I allow the user to simply hit enter to select and exit the combo box? Dave Tom Ogilvy wrote: look at the match related properties of combobox. -- Regards, Tom Ogilvy " wrote: hi all, I have a timesheet entry form that requires employee # to operate. Since employee # is something that is assigned, and not reliably referenced on timecards, the operator will use the name to find the EENUM. To do that, I created a combo box that is called on the "BeforeDoubleClick" command. The data that populates it is 6 columns of info, starting with EENUM, Name, Status... and 3 more columns to help the operator identify the correct one to select. I have set the textcolumn so that it references the 2nd column - the names, and the target cell will be populated with the EENUM when the operator closes the combo box. It all works smashingly. But, I want to tune things up a little more. We have 1000+ employees, so the list that is called up is quite large. I would like the drop down button to be automatic & while the employee is typing a name in, for the list to be filtering on every keystroke. I would also like the combobox to close when the operator hits enter, and not force them to use the mouse and click elsewhere on the screen. Am I just dreaming, or is this indeed possible? Thanks in advance for all you help, Dave |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box filter with autocomplete
Hi Tom,
It's not the retracting only that I want. I want it to close completely. Is there an 'on enter' event that I can work with? Thanks, Dave Tom Ogilvy wrote: It retracts for me when I hit enter. Even when I have your change event in effect. -- Regards, Tom Ogilvy "davy_gravy" wrote: Hi Tom, Thanks for your help. I have the autocomplete working - that's not the issue. I've also got the dropdown menu opening automatically, by using: Private Sub TempCombo_Change() TempCombo.DropDown End Sub How do I allow the user to simply hit enter to select and exit the combo box? Dave Tom Ogilvy wrote: look at the match related properties of combobox. -- Regards, Tom Ogilvy " wrote: hi all, I have a timesheet entry form that requires employee # to operate. Since employee # is something that is assigned, and not reliably referenced on timecards, the operator will use the name to find the EENUM. To do that, I created a combo box that is called on the "BeforeDoubleClick" command. The data that populates it is 6 columns of info, starting with EENUM, Name, Status... and 3 more columns to help the operator identify the correct one to select. I have set the textcolumn so that it references the 2nd column - the names, and the target cell will be populated with the EENUM when the operator closes the combo box. It all works smashingly. But, I want to tune things up a little more. We have 1000+ employees, so the list that is called up is quite large. I would like the drop down button to be automatic & while the employee is typing a name in, for the list to be filtering on every keystroke. I would also like the combobox to close when the operator hits enter, and not force them to use the mouse and click elsewhere on the screen. Am I just dreaming, or is this indeed possible? Thanks in advance for all you help, Dave |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box filter with autocomplete
Hi Tom,
I figured out how to get out of the combo box without the mouse - enter to select line from the drop down and to close the drop down, esc to return the focus to the spreadsheet, and enter to trigger Private Sub Worksheet_SelectionChange(ByVal Target As Range) to close and hide the combo box. thanks again for you help. Dave davy_gravy wrote: Hi Tom, It's not the retracting only that I want. I want it to close completely. Is there an 'on enter' event that I can work with? Thanks, Dave Tom Ogilvy wrote: It retracts for me when I hit enter. Even when I have your change event in effect. -- Regards, Tom Ogilvy "davy_gravy" wrote: Hi Tom, Thanks for your help. I have the autocomplete working - that's not the issue. I've also got the dropdown menu opening automatically, by using: Private Sub TempCombo_Change() TempCombo.DropDown End Sub How do I allow the user to simply hit enter to select and exit the combo box? Dave Tom Ogilvy wrote: look at the match related properties of combobox. -- Regards, Tom Ogilvy " wrote: hi all, I have a timesheet entry form that requires employee # to operate. Since employee # is something that is assigned, and not reliably referenced on timecards, the operator will use the name to find the EENUM. To do that, I created a combo box that is called on the "BeforeDoubleClick" command. The data that populates it is 6 columns of info, starting with EENUM, Name, Status... and 3 more columns to help the operator identify the correct one to select. I have set the textcolumn so that it references the 2nd column - the names, and the target cell will be populated with the EENUM when the operator closes the combo box. It all works smashingly. But, I want to tune things up a little more. We have 1000+ employees, so the list that is called up is quite large. I would like the drop down button to be automatic & while the employee is typing a name in, for the list to be filtering on every keystroke. I would also like the combobox to close when the operator hits enter, and not force them to use the mouse and click elsewhere on the screen. Am I just dreaming, or is this indeed possible? Thanks in advance for all you help, Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autocomplete combo box | Excel Worksheet Functions | |||
Help with VBA, Combo Box and Filter | Excel Discussion (Misc queries) | |||
Filter using combo box | Excel Programming | |||
Combo box to filter | Excel Programming | |||
Combo box to filter | Excel Programming |