Hi

How do I incorporate check boxes into my tab order? I'm creating an
excel client form where someone must fill in data in either text, check
boxes and/or drop down lists. I've used the following to set the tab
order

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$B$4"
Range("G4").Select
Case "$G$4"
Range("J4").Select
Case "$J$4"
Range("B5").Select
End Select
End Sub

which works for text boxes and drop down lists, but not check boxes.

Any ideas?
Thanks,
Dre

Is there a reason why you don't want to use the 'TabIndex' property of the
objects on the form?
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Dre" wrote:

Hi

How do I incorporate check boxes into my tab order? I'm creating an
excel client form where someone must fill in data in either text, check
boxes and/or drop down lists. I've used the following to set the tab
order

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$B$4"
Range("G4").Select
Case "$G$4"
Range("J4").Select
Case "$J$4"
Range("B5").Select
End Select
End Sub

which works for text boxes and drop down lists, but not check boxes.

Any ideas?
Thanks,
Dre

I'm not sure what that does. I've been using the formula below because
I want to create a specific range of cells (without using the name
range trick as my list exceeds that amount) that the person has to tab
through (while entering data). As I said, the data entering & tab
formula works together with the exception of the check boxes (Yes &
No). I tried using Option buttons as well but it still kicks the
designated tab order out of sorts.

Am I making any sense? Would the TabIndex thing work? And how?

Cheers,



Gary L Brown wrote:

Is there a reason why you don't want to use the 'TabIndex' property of the
objects on the form?
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Dre" wrote:

Hi

How do I incorporate check boxes into my tab order? I'm creating an
excel client form where someone must fill in data in either text, check
boxes and/or drop down lists. I've used the following to set the tab
order

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$B$4"
Range("G4").Select
Case "$G$4"
Range("J4").Select
Case "$J$4"
Range("B5").Select
End Select
End Sub

which works for text boxes and drop down lists, but not check boxes.

Any ideas?
Thanks,
Dre

Sorry Andrea. I misunderstood you. I thought you were using a UserForm.
After re-reading your post, I realize you are putting checkboxes directly on
your worksheet.
Assuming that you are using the ControlBox checkboxes and NOT the Forms
checkboxes, I googled the following at...
---------------------------------------------------------------------
http://groups.google.com/group/micro...1bfce 29bef48
---------------------------------------------------------------------
SETUP CHECKBOX TO CHECK OR CLEAR USING KEYSTROKES
8. for each checkbox you will have to right click, choose
Format Control on the menu that pops up, click on Control
tab, in Cell Link box type in the letter & number of the
cell directly under that checkbox (for example: C3), and
click OK
9. now click your cursor somewhere on the sheet & use
your arrows to move to that cell (C3). type in "1", hit
enter, and cell will check. type in "0", hit enter,and
cell will uncheck. (you could also key in the word "TRUE"
or "FALSE" to check/clear the checkbox, or click on the
checkbox with the mouse)


HIDE THE TYPING OF 1 OR 0 IN THE CELL
10. now it looks funny for 1 or 0 (or true/false) to be
there & you probably do NOT want it there so ...
11. move your cursor back to that cell (C3), click on
Format menu, choose cells, choose Number tab, under
Category choose Custom, in the Type box type in ;;; (three
semicolons), and click OK. Now the contents of the cell
are hidden (the words not the checkbox) and they only show
up in the "formula bar" at the top. this must be done for
each checkbox on the wroksheet or ...
12. shortcut to do this for each checkbox: before hitting
any other keys other than arrows, tab, or enter, move your
cursor to each cell that has a checkbox sitting over it
that you assigned a cell link to in step 7 & hit F4 (or
you can just repeat step 11 for each checkbox)
---------------------------------------------------------------------
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Dre" wrote:

I'm not sure what that does. I've been using the formula below because
I want to create a specific range of cells (without using the name
range trick as my list exceeds that amount) that the person has to tab
through (while entering data). As I said, the data entering & tab
formula works together with the exception of the check boxes (Yes &
No). I tried using Option buttons as well but it still kicks the
designated tab order out of sorts.

Am I making any sense? Would the TabIndex thing work? And how?

Cheers,



Gary L Brown wrote:

Is there a reason why you don't want to use the 'TabIndex' property of the
objects on the form?
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Dre" wrote:

Hi

How do I incorporate check boxes into my tab order? I'm creating an
excel client form where someone must fill in data in either text, check
boxes and/or drop down lists. I've used the following to set the tab
order

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Address
Case "$B$4"
Range("G4").Select
Case "$G$4"
Range("J4").Select
Case "$J$4"
Range("B5").Select
End Select
End Sub

which works for text boxes and drop down lists, but not check boxes.

Any ideas?
Thanks,
Dre