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.

 

[Robert Allan]

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

By the way, If you can think of anything, I also am trying to figure out how to cause my pull down menus to work when I use the Down-arrow key.

 

[Robert Allan]

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

 

[Robert Allan]

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

Thank You! Thank you! Thank you! This lead me to the best solution. I had to go to the main module and change all my line references. But what I did was to simply remove all the blank lines in-between the input fields, and enlarged the row height on the input fields. This solved all of my problems (even the Enter key problem) except the Down arrow key, and I can live with that. Hear is what my Data Entry Form looks like now:

 

[Michael M]

Glad you found a suitable solution Robert.
AND
Glad WE could help..?

 

[Robert Allan]

Thank You! Thank you! Thank you! This lead me to the best solution. I had to go to the main module and change all my line references. But what I did was to simply remove all the blank lines in-between the input fields, and enlarged the row height on the input fields. This solved all of my problems (even the Enter key problem) except the Down arrow key, and I can live with that. Hear is what my Data Entry Form looks like now:View attachment 10598

I added borders and now this is what it looks like: