MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Checkboxes (forms), and linking to cells?

Posted by Daryl on December 06, 2001 6:00 AM

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.

Posted by Juan Pablo G. on December 06, 2001 6:41 AM

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.