Hi Nigel,

Not quite sure what exactly your asking for here but if you want to
stop the code 'flashing' then use

Application.ScreenUpdating = False

however because the code is triggered when the combobox looses focus
it cant be guaranteed that it will be in view while the code is
running as the user could simply select a different sheet!

If you are a bit more sprecific l am sure we can help

HTH

Michael