View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
michael.beckinsale michael.beckinsale is offline
external usenet poster
 
Posts: 274
Default keeping an object in view

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