Alternatives to SenKeys and OnKey in VBA/Macros

I've read some opinions online, saying that whenever somebody is using SendKeys there is usually a better way to obtain their objective. I'm interested in the alternatives; I use Excel for Mac at home (which doesn't recognize SendKeys) and would like to learn some work-arounds. Here's a relevant example of what I'm talking about:

Please Login or Register  to view this content.

Tab_Enter is the macro that runs when I hit tab, and it works fine in MS Excel. The macro is simply ActiveCell.Offset(1,0).Select, so essentially the tab key functions like the enter key In a particular row that I specified in VBA.

In another worksheet, I'm using SendKeys "+{ }" which selects the entire row of the ActiveCell. Perhaps there is some Applescript approach to solving my problem, but I'm also interested in some more robust VBA language that I can progress with. Thanks in advance for your time and attention.