ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Controlling cell selection during data entry (https://www.excelbanter.com/excel-programming/277341-controlling-cell-selection-during-data-entry.html)

BrianG[_3_]

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