Is there a way to use keyboard "enter" or "tab" to leave a combobox?

  • Thread starter Thread starter Pal
  • Start date Start date
P

Pal

Is there a way to use keyboard "enter" or "tab" to leave a combobox?
Currently I have to click somewhere else with the mouse to leave the box
Thanks
Pal
 
Try setting the MatchEntry = False on the combo box
propertys list. Three of four different property settings
effect how the combo box responds to tab and enter. But
matchentry property may do it.
 
I haven't tried this but how about xlPasteFormulas?

Paste Optional Variant. The part of the range to be
pasted. Can be one of the following XlPasteType constants:
xlPasteAll, xlPasteFormulas, xlPasteValues,
xlPasteFormats, xlPasteNotes, or xlPasteAllExceptBorders.
The default value is xlPasteAll.
 
Back
Top