I am having issues with the ActiveX Controls on a spreadsheet. I have 3 Comboboxes and 2 textboxes. I use KeyCode 9 to tab threw the controls, but noticed that when I tab over instead of making that control activate, it's disappearing.
[VBA]Private Sub txtBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 9 Then
CmbResolution.Activate
End If
End Sub[/VBA]
I don't understand why, but if i click somewhere on the spreadsheet it re-appears. Not sure if this a known issue with keycode and comboboxes.
I am using excel 2007.
Any ideas how to fix this?