Combobox onkey down and up event

[Ohad1997]

I want to hover over a selection rather then actually selecting it when i press the down or up key inside a combobox, how can i achieve this?
(yes i know hovering with the mouse does the same thing, i want to able to hover over a selection without actually selecting it with the down and up buttons)

 

[Jaafar Tribak]

I want to hover over a selection rather then actually selecting it when i press the down or up key inside a combobox, how can i achieve this?
(yes i know hovering with the mouse does the same thing, i want to able to hover over a selection without actually selecting it with the down and up buttons)

Do you want this because you don't want to trigger the combobox change event? and where is you combobox? In a userform or on a worksheet ?

 

[Ohad1997]

No, other calculation are the reason im avoiding it, in a worksheet

 

[Ohad1997]

Any idea how to do that?

 

[Jaafar Tribak]

Hi Ohad1997,

This turned out to be more complicated than I initially thought ... I had some code in mind but after implemnting it didn't work.

I'll give this another shot and see if anything comes up.

 

[Ohad1997]

Thx jafaar u are the real mvp <3

 

[Jaafar Tribak]

Thx jafaar u are the real mvp <3

Thank you ohad1997.

I had a little try at this today but with partial success. I have been trying to come up with an elegant API-based solution but I am not satisfied with the result.

I have an idea though. Why not have an empty combobox and a hidden ListBox poulated with the list iems.. Upon clicking the empty combobox dropdown button, show the ListBox below it and hide the ListBox back when done .. You will add some basic plumbing vba code to connect the two controls and you will then get the effect you need.

 

[Ohad1997]

I dont know if its possible to combine the code u made to scroll a combobox via mouse wheel and applying the method u suggested