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.
 
You are in the "Excel Programming" forum, so :-
ActiveSheet.Range("A1").Selec
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform combobox matchrequired = True; error with no selection 4
Combobox filtering 2
Combobox Exact Match control 4
UserForm Combobox Change Event 4
MSForms 2.0 Combobox problem 1
Make a maro run upon leaving a cell 0
populate combobox from worksheet in different workbook 3
ComboBox Focus 3

Back
Top