need to move cursor to specific fields
I am trying to set up an excel order form - I have created the form but I
would like the tab or cursor to move/transition to specific fields not all of them. When hitting the tabs or arrow keys it is a lot of repetitive motion. Would like to go from say a1 to a4 to b5 to k12 etc Does anyone know of a way to do this? |
need to move cursor to specific fields
Cindy
There are a few methods of achieving this. See Bob Phillips's site for a couple. http://www.xldynamic.com/source/xld.xlFAQ0008.html You could also employ event code to jump around to non-contguous random cells. If interested, post back. Gord Dibben MS Excel MVP On Thu, 17 Jan 2008 15:24:01 -0800, Cindy wrote: I am trying to set up an excel order form - I have created the form but I would like the tab or cursor to move/transition to specific fields not all of them. When hitting the tabs or arrow keys it is a lot of repetitive motion. Would like to go from say a1 to a4 to b5 to k12 etc Does anyone know of a way to do this? |
All times are GMT +1. The time now is 10:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com