Focus after combobox

[Ed]

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.

 

[Dave Peterson]

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]

This kind of works. It brings the focus back to the sheet, but to the place
where I last had the cursor, which is not where I need it. If I have the
combobox on A5, can I bring the curosr back to A5?

 

[Dave Peterson]

Oops.

You could use something like:

Option Explicit
Private Sub ComboBox1_Change()
Me.ComboBox1.TopLeftCell.Offset(0, 5).Activate
End Sub

Do you really mean under the combobox? If yes, then drop that .offset(0,5).

This kind of works. It brings the focus back to the sheet, but to the place
where I last had the cursor, which is not where I need it. If I have the
combobox on A5, can I bring the curosr back to A5?

 

[Ed]

I got it.

Thanks so much for your help!
--
Thanks - Ed

This kind of works. It brings the focus back to the sheet, but to the place
where I last had the cursor, which is not where I need it. If I have the
combobox on A5, can I bring the curosr back to A5?