make vba code for multiple comboboxes

[Davo]

Could anyone suggest how I might simplify the following. I have many comboboxes in a worksheet and I want it so that when someone is in the combobox and they press "enter" then you move to the next cell. Right now I make a vba code for each combobox and I know theres a simple way to cycle through them. Take a look at the code and let me know what you think.
Thanks!

Please Login or Register  to view this content.

This goes on until ComboBox 41.

[Leith Ross]

Hello Davo,

Are these ComboBoxes on a worksheet or a VBA UserForm? I am guessing worksheet. Add the code below to a VBA module in your workbook.

Please Login or Register  to view this content.

Call the macro from each ComboBox_KeyUp event like this...

Please Login or Register  to view this content.