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.
|