Controlling cell selection during data entry
I've created a purchase order form using Excel97. I'm brand new to
VBA. Regardless of that shortcoming I've still been able to automate it somewhat (thanks to lots of info found searching this group). Now I'm wondering if there is a way to control cell selection as data is entered. I have "Move selection after Enter" set to "Right" but active cell selection moves off of the form. I'd like to have like a carriage return after a certain column is reached. But I want to activate the cell in column "B" of the next row instead of "A". Specifically, the last column of data is "AA", the first is "B". So, once Enter is hit after data entry in say, cell "AA1", I'd like the next active cell to be "B2", then "AA2" to "B3", etc. Is this possible? BrianG |
All times are GMT +1. The time now is 11:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com