View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
George[_26_] George[_26_] is offline
external usenet poster
 
Posts: 7
Default Arrow key operation among multiple TextBoxes in a UserForm

In my computer/form, Right and Left arrows do not work at all.
123
456
789
If I'm on Box 1, Down arrow goes down but skips a row to Box 7.
If I'm on Box 7, Up arrow goes up but skips a row to Box 1.
Similar actions in other columns (Box 2 Down goes to Box 8).
Up and Down arrow keys ignore TabIndex and TabStop = False



gocush wrote:
Not that I know of. I haven't checked this out but I think the up

arrow
would go back from box 7 to 6 then 5..... to 1. In other words you

can't go
straight to jail without passing Go. (as set up in the Tab Order:

Rt click
the formTab Order

Barring this to get directly from 7 to 1 requires a left mouse click.

"George" wrote:

Tab and Shift-Tab work OK.

Boxes in this arrangement:
123
456
789
After completing boxes 1 - 6 in rows 1 and 2, focus is on box 7 of
third row, user sees mistake in box 1. Easiest method (in data

sheet)
is arrow up to box 1.
Can code do this on a userform?