Excel Checkboxes (forms), and linking to cells?

Hello all. :)

I'm using checkboxes (in Forms, not ActiveX) in my spreadsheet. This sheet's main purpose will be for data entry.

What I would like to do, is that when I push use the arrow keys or TAB to move the highlight around the spreadsheet, I'd like the checkboxes to be highlighted... instead of the cell where they are. That is, I'd like to be able to just hit TAB and go from checkbox to checkbox, instead of cell to cell... does that make sense? I'm not quite sure how to explain this, but I'm hoping someone can understand this.

Thanks in advance for any help.

Form CheckBoxes are basically shapes, just like a rectangle or an oval. If you select any shape and hit TAB you'll go to the next available Shape, BUT, you'll be in Edit mode.... therefor, if hit SPACE (Like you would expect) you'll just erase the caption of the CheckBox.

You can do this by using a UserForm and ActiveX Checkboxes, where you can specify the Tabulation order of controls.

Juan Pablo G.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

Archive of Mr Excel Message Board

Checkboxes (forms), and linking to cells?

Re: Checkboxes (forms), and linking to cells?