Tab Through Checkboxes

[jeremy8fc]

I'm nearing the end of creating a signup sheet for us to use at my work when signing up customers. I'd really like to tab through the sheet, but I'm using checkboxes for some things and I don't know how to get the checkboxes to be part of the tab order. It's common to use tap/spacebar in forms, so I can't believe this is not possible in excel.

Any thoughts?

 

[HalfAce]

You're using the checkboxes on the sheet itself(?), or are you doing this in a userform?
On the sheet, the tab button will simply tab through the cells (If you protect the sheet it'll tab through the unlocked cells, skipping the locked ones). The only way I know of to set the tab order is if you're using a userform.

 

[Tazguy37]

As HalfAce said, you can only (AFAIK) dictate the tab order of boxes on a userform. Just set the TabStop = True for each control that needs to have a tab stop, and then set the TabIndex property for each control in the order you want them to be selected. A TabIndex of 0 will be the first control selected.

Hope that helps!

 

[daniels012]

Also as long as your checkboxes are unprotected, you will be able to go to them as well.

Michael

 

[jeremy8fc]

Thanks for all the advice...I guess I'll start looking into userforms...right now I do have the checkboxes on just the sheet.