PDA

View Full Version : 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)