Hi Michael

It works great thankyou. Thats a great idea but how do i get the next combo
box to take the focus?

Many thanks Nigel

"michael.beckinsale" wrote:

Hi Nigel,

inserting :

Application.ScreenUpdating = False

as your 1st line of code will stop that movement for you whilst the
code is running. Depending on which version of Excel you are running
it is set back to True when the procedure ends. Your curent code
selects cell A1 so that will be the cell selected cell when the code
ends, perhaps you could change this so that the next combo box is
selected?

HTH

Michael