I double clicked on the combobox (while in design mode) and pasted this in:
Option Explicit
Private Sub ComboBox1_Change()
ActiveCell.Activate
End Sub
It seemed to work ok.
Ed wrote:
I created combo boxes using it's properties, not vb programming, ie. using
the Control Toolbox and using the items properties. But how do I put the
focus back on the spreadsheet so I can tab to the next column? Right now I
am forced to click in the next column to regain focus on the sheet.
--
Thanks - Ed
--
Dave Peterson