Assign a function key to combobox

[Berna11]

Good evening in the attached file I have 3 comboboxes and I would like to move from one combobox to another via F1, F2, F3.

I have inserted in the form of the sheet:

Please Login or Register  to view this content.

in the standard form:

Please Login or Register  to view this content.

but it does not work.
can you tell me what's missing?
Thank you.

[6StringJazzer]

it does not work.

Please explain what "doesn't work" means.

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
• Does it hang?

SetFocus in not available for ActiveX comboxes in a worksheet, only in a UserForm. If you use Select, it will Select the combobox.

I am a little unclear as to how you want to use this. If you make a combobox active you still have to click and scroll to select an item. It is just as easy to click on the combobox--a single click will select the combobox and display the dropdown list.

[Berna11]

Thanks for the reply
gives me the run-time error 424
Object required.

I need to use only the keyboard and not the mouse if possible

[6StringJazzer]

You have to update your code to qualify the reference to the combobox.

Please Login or Register  to view this content.

Once it is selected, I don't know if you can activate the dropdown with a keystroke.

[Berna11]

Modifying the code as indicated goes to Excel block.

[6StringJazzer]

What do you mean by "Excel block"?

[Berna11]

Good morning
"Excel block"?
excel crashes

I'll send you the file you can try.
Thank you

[6StringJazzer]

It does not crash for me. It selects the desired combobox.

I tried using Activate instead of Select. It allows you to scroll through the combobox selections with up arrow/down arrow, although the dropdown list does not actually drop down. That may meet your requirements.

[Berna11]

With Activate it goes better Exxcel does not crash

there is this problem:
If the cursor is on any cell, pressing F1-F2-F3,
* the focus goes on the correct combobox, however, if I find the example cursor in combobox1 and press F2 I would like to switch to the combobox2 it does not move.

Can anything be done?