View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lluis Escude Lluis Escude is offline
external usenet poster
 
Posts: 6
Default From cell/combo to combo/cell

After I've typed data + return key to a specific cell, say C5, I want the
focus to be automatically transferred to a combobox in the same worksheet.
What code do I need and where -in what event handler- must it be placed?
Then, after I've selected one of the combo items (and maybe -maybe not- hit
the return key as well) I want the focus to be automatically set to some
other cell, such as C8. Same question as above.

The idea is to cycle through a number of cells and comboboxes so that no
cells can be selected/activated that don't require input data.