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