Tab order with check boxes
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 |
Tab order with check boxes
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 |
Tab order with check boxes
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 |
All times are GMT +1. The time now is 01:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com