Hi everyone
I have a Excel 2003 sheet which is used for various text inputs in unprotected cells (sheet is locked). Since it's a printable form with two columns, the field order is not correct. Now I'm looking for a VBA script to set a custom cell order when using the tab or enter keys. In other words, I want to be able to specify that after cell A1 comes cell C3, then A6, then C12, etc., and back to the beginning. The tab jumps should work even if no text input is made in the fields.
Any ideas?
Thanks! LY
I have a Excel 2003 sheet which is used for various text inputs in unprotected cells (sheet is locked). Since it's a printable form with two columns, the field order is not correct. Now I'm looking for a VBA script to set a custom cell order when using the tab or enter keys. In other words, I want to be able to specify that after cell A1 comes cell C3, then A6, then C12, etc., and back to the beginning. The tab jumps should work even if no text input is made in the fields.
Any ideas?
Thanks! LY