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
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