When I was using Excel 2003, I could easily adjust which direction the cursor would move—either to the right or down—after I entered data in a cell. But Office 2007 doesn’t seem to give me a choice.
By default, when you select a formula or source field in a dialog box, Enter mode is activated. You can see this in the ...
A Visual Basic text box may be used to capture user input in Microsoft Excel. Typically, users type data into spreadsheet cells, but text boxes read data from dialog boxes that do not contain cells.