TAB Order Workbook on KB

**sswcharlie** · 04-02-2012, 06:16 PM

Hi Byundt and others

I have downloaded your workbook from VBAX KB for the tab order. It works very well. I have about 20+ tabs and have modified the code to suit.

However with your sheet and my sheet both do the same thing. That is when entering data and you go back to an earlier entry on the same page and want to change the value, when you hit 'Delete' key it deletes all the data from all of the tab order cells you have entered, meaning you have to start again and enter data accurately.

Is there a way to stop deleting all data on tab cells?

Is it feasible to use an 'event, ie pressing of 'delete' key to tell it only to delete value in 'active cell' ? I have tried to do this but got lost in the process.

Your comments would be much appreciated.

Regards

Charlie Harris

**Aussiebear** · 04-02-2012, 10:24 PM

Record the order of setting up the tab order and set it as a macro to fire after the delete function

**sswcharlie** · 04-05-2012, 05:05 PM

Hi AussieBear

Thanks for your response. I hope I have interpreted your post correctly. I have set up a new event macro, as I think you meant, but not working at this point of time. Type 13 mismatch.

Can you look at attached WB and comment. Maybe I have got it all wrong!

Thanks

Charlie
(the Kiwi)

04-02-2012, 06:16 PM	#1
sswcharlie VBAX Regular Joined: Jul 2007 Posts: 50 Kb Entries: 0 Articles: 0	TAB Order Workbook on KB Hi Byundt and others I have downloaded your workbook from VBAX KB for the tab order. It works very well. I have about 20+ tabs and have modified the code to suit. However with your sheet and my sheet both do the same thing. That is when entering data and you go back to an earlier entry on the same page and want to change the value, when you hit 'Delete' key it deletes all the data from all of the tab order cells you have entered, meaning you have to start again and enter data accurately. Is there a way to stop deleting all data on tab cells? Is it feasible to use an 'event, ie pressing of 'delete' key to tell it only to delete value in 'active cell' ? I have tried to do this but got lost in the process. Your comments would be much appreciated. Regards Charlie Harris
Local Time: 01:22 AM Local Date: 05-20-2013

04-02-2012, 10:24 PM	#2
Aussiebear Moderator VBAX Regular Joined: Dec 2005 Posts: 2,761 Kb Entries: 0 Articles: 0	Record the order of setting up the tab order and set it as a macro to fire after the delete function Remember To Do the Following.... Use the VBA button to correctly submit your code to the forum. Mark your thread as Solved if satisfied by using the Thread Tools options
Local Time: 04:22 PM Local Date: 05-20-2013 Location: