Userform Combobox behavior on Keydown

Greetings,
I have a combobox in a userform I'd like to modify.
User tabs into the combobox (currently this is just fine).
On keydown, display the drop down (also fine).

On key down again, cycle through the items in the dropdown. When it gets to the last item, I'd like it to start over from the top and visa versa.

Right now strange things happen- it goes 1 to 3 on keydown and on the next keydown selects the final item, skips the next text box and shifts the focus to next item on my userform.

Thanks in advance for your help.

Please Login or Register  to view this content.

It's all very strange. I think you might have to disable the other controls.

sample.xls


Yes! That's part of the problem I'm having.
And when I try the up key, it gets stuck at the top.
(I do want to have a blank as a possible option - that part isn't a mistake.)

Thanks much.

Originally Posted by Norie

The code I posted works for the down key.

Thanks, that works beautifully. I'll try my hand at reversing it for the up key.