I haven’t followed this but I think Charlie has a older version ( if that makes a difference) ??
Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Asa Rossoff Sent: Saturday, March 24, 2012 2:27 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Turn Tab Order on/off Hi Charlie, Good day - I'm not sure what the trouble is. Works in Excel 2010. Just to reiterate, the macro does not make the tab key go from field to field. It only has effect when a field (listed cell) is edited. What the macro does: after you've edited a cell in the list, it selects the next cell in the list. If you don't edit a cell, the macro does nothing, and you can tab all over the place. to troubleshoot the macro, you can go in the VBE/macro editor (Alt-F11) and set a breakpoint on a line in the macro. To set a breakpoint, you can hit F9 on a line. Then the macro will stop on that line (if the macro runs at all). If it doesn't run, then that would explain why it doesn't do anything and we can try to figure out why. If it does run, the macro editor will pop up on the screen with the macro running but paused. You can then hit F8 to execute one line at a time (or Debug menu -> Step Into for the same). See if you can figure out where the marco is failing you. Give it a shot, and post back. I can try to help you debug it if you need more help. It's kind of hard to do by email like this, though. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Cab Boose Sent: Saturday, March 17, 2012 2:47 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Turn Tab Order on/off Good Day Asa Are you able to assist with this for me. Would be greatly appreciately. Thanks Charlie On Wed, Mar 14, 2012 at 9:45 AM, Cab Boose <swch...@gmail.com> wrote: Hi Asa At the moment the H1 setting makes no difference. The sheet works like normal with the setting at activate or deactivate, and not in tab order. Thanks Charlie On Sun, Mar 4, 2012 at 10:09 PM, Asa Rossoff <a...@lovetour.info> wrote: Hi Charlie, The "button" is actually just a cell that is colored. It has Data Validation enabled for that cell that restricts values to "Activate" and "Deactivate". The "tab order" macro seems to be pretty straightforward and I would expect it to work with Excel 2000, but I am not an expert at what is and is not supported. The macro moves the selection to the next data entry cell only when a cell is edited. Not particularly when tab is pressed. Can you confirm that when cell "H1" says "Activate" and you edit one of the cells listed at the end of this sentence and hit either tab or enter to leave the cell that the selection does not go to the next cell in this list: h8, h9, h10, h11, h13, l11, l12, h17, k17, h18, k18, k21, k22, n26, n27, n31, k37, e82, f82, h82, j82, e83, f83, h83, j83, e84, f84, h84, j84, e85, f85, h85, j85, e86, f86, h86, j86, e87, f87, h87, j87, e88, f88, h88, j88, e89, f89, h89, j89? Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Cab Boose Sent: Saturday, March 03, 2012 10:07 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Turn Tab Order on/off HI In attached workbook Ashish has produced a great macro but he is not use to XL2000, only later ones. There is a button at top of worksheet to turn on/off the macro that sets the tab order. Not working currently, is there an adjustment to make for XL2000 ? Once going, please check when in tab order mode that if a entry is incorrect and user hits delete for that cell that it does not delete info in all tabbed cells. Your assistance appreciated. Charlie -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
