Tab Control Problem

[Robert Allan]

Tab Control Problem

Once again my lack of knowledge pops up on me. Still working on my Finance System Data Entry screen. This form was created right on the worksheet and is not a user form, just cells and 4 control buttons. My problem is that when that when I hit Tab key or the Right- arrow key it goes to the next cell on the right until it hits the far side of the form. And when I hit the Enter key or the Down-arrow key it goes to the next line, which is always a blank every other line. I don’t like that. I want it to jump from entry field to entry field. Any help would be greatly appreciated, even if somebody can suggest some software that would do the trick. I would certainly buy it. Just one more chance for MrExcel to help.

 

[Michael M]

What column is the data entry on ?
AND what is the address of the first entry point ?
AND
by the look of it you would need to jump down 2 rows to get to the next entry point ?

 

[Robert Allan]

What column is the data entry on ?
AND what is the address of the first entry point ?
AND
by the look of it you would need to jump down 2 rows to get to the next entry point ?

The data entry column is column "I", and the first entry point is "I6". And, yes you are right I do have to jump down 2 rows to get to the next entry point.

 

[Michael M]

Ok, so based on that info I would set up a named range to step through the required cells
Have a look here for step by syep instructions on how to....

Jump to the Next Data Entry Cell in Excel - Contextures Blog

If you're filling in a form, the data entry cells might be scattered throughout the worksheet. You'd like a quick and easy way to move through the cells, in a

contexturesblog.com

 

[Michael M]

Also a worksheet_change event pasted into the sheet module

Sub Worksheet_change(ByVal target As Range)
If target.Column <> 9 Then Exit Sub
If target.Value <> "" Then
ActiveCell.Offset(1, 0).Select
End If
End Sub

 

[Robert Allan]

Also a worksheet_change event pasted into the sheet module

Sub Worksheet_change(ByVal target As Range)
If target.Column <> 9 Then Exit Sub
If target.Value <> "" Then
ActiveCell.Offset(1, 0).Select
End If
End Sub

Maybe I just plain ignorant, but I not sure where you mean to put it. I tried putting it into my Data Entry sheet, but that had no effect. The following is a list of all the modules in the project:

 

[Dave Patton]

Could you eliminate the blank lines and secure the same appearance with formatting?
- make row taller
- make alignment middle instead of bottom

T202004a.xlsm
	A	B	C	D
1
2	Date
3	Source
4
5
1b

 

[Michael M]

It goes in the sheet module that contains the Finance Data Entry Form....BUT....are you on a Mac ?
If so, I don't know whether this code will work on a Mac.

 

[Robert Allan]

Ok, so based on that info I would set up a named range to step through the required cells
Have a look here for step by syep instructions on how to....

Jump to the Next Data Entry Cell in Excel - Contextures Blog

If you're filling in a form, the data entry cells might be scattered throughout the worksheet. You'd like a quick and easy way to move through the cells, in a

contexturesblog.com

I got to fast and had not look into this solution, but it has real promise. My tabs work fine doing it this way. I just added it to my macro that launches the form. Now if I can figure out how to get the Enter key to go to the next input line.

 

[Robert Allan]

Ok, so based on that info I would set up a named range to step through the required cells
Have a look here for step by syep instructions on how to....

Jump to the Next Data Entry Cell in Excel - Contextures Blog

If you're filling in a form, the data entry cells might be scattered throughout the worksheet. You'd like a quick and easy way to move through the cells, in a

contexturesblog.com

Thinks again for sharing this solution with me, it put me on to a whole host of other things.