After checking control checkbox returning focus to the sheet

[Don Wiss]

After a user has checked a control checkbox, the focus normally remains on
the control. I don't like this. Now to return the focus to the sheet I'm
using:

ActiveWindow.RangeSelection.Select

But this is less than perfect. If the active cell is not in view, the
spreadsheet will jump to put it in view. Is there some other way I can
return the focus to the sheet without this quirk?

Thanks, Don <donwiss at panix.com>.

 

[BrianB]

ActiveSheet.Range("A1").Selec

 

[BrianB]

Sorry, this is what you really want :-

ActiveWindow.VisibleRange.Cells(1, 1).Selec

 

[Vic Eldridge]

The checkboxes from the Forms toolbar don't take focus when clicked.
But if you must use the ActiveX checkbox, try the following.

Private Sub CheckBox1_Click()
SendKeys "{ESC}"
End Sub


Regards,
Vic Eldridge

 

[Don Wiss]

The checkboxes from the Forms toolbar don't take focus when clicked.
But if you must use the ActiveX checkbox,

I know this. I really dislike the ActiveX ones. But the checkbox on the
Forms toolbar, for some reason, won't move and size with cells. In this
application I need them to disappear when the section of rows they are on
is hidden.

SendKeys "{ESC}"

Okay. I'll try this when I get back into the office. Looks like a good
solution.

Don <donwiss at panix.com>.