Excel Visual Basic (VBA) for Beginners - Part 3 of 4: Positioning and Offset

Learn the basics of visual basic (VBA) programming for Excel spreadsheets with this series of 4 videos.

Watch all of Tiger's Excel VBA tutorials in this playlist:

Also check out our Excel VBA for Post-Beginners series, where we apply code to an everyday task:

🎁YOUR EXCEL CHEATSHEET
🎁1 Page Summary Of What You Need To Know

Get in touch with us online, we would love to hear from you.

[TigerSpreadsheetSolutions]

Code to move back to the 'HOME' cell:

Sub Go_Home

Range("G5").select

End Sub

[WarrenCromartie]

It's unusual for an experienced coder to be able to teach to absolute beginners without making huge assumptions about the students prior knowledge. You have managed to explain the basic very clearly indeed, avoiding jargon and beng over technical. Thankyou!

[favorite]

Absolutely helpful! It’s been 6 years since this video was uploaded but still can’t find any videos that explain better!

[scotthewett]

A way to remember that positive numbers move right or down is to think of the movement from the origin of the sheet at cell A1. A positive number increases the distance from the origin, either to the right or down. In contrast, a negative number decreases the distance from the origin, cell A1.

[peterjones]

As professional as you are in VBA, you clearly haven't forgotten what it's like to code for the first time and see it work. Wonderful stuff! I'm learning and it's easy - thanks to you!

[fionarangel]

The emphasis of formatting used in these videos kind of makes me want to marry this guy <3

[nuraneesajabbar]

Hey, I'm a beginner for VBA. Its great to found all your tutorials, easy to understand so far but still need time to keep remember the syntax. Thank you for all your videos! Will study one by one.

[jaisha]

you are really explaining well and its really understandable for us.

thanks for sharing your knowledge

[martincoolman]

I just want to take the time to say your a good teacher. Keep it up.

[deepakkumarpatel]

@Tiger Spreadsheet Solutions Trying to understand VBA through your channel. Thanks for the content.

[arturojoseg]

Thanks a lot for your help!! You're the best!

[peteradeteacher]

i have been searching for someone like u with easy videos to understand. thankyou very much

[NaviiiiiDosanjh]

Thank you for putting all these videos out there. They gonna help me a lot. Thank you once again. 🙏🏼🙏🏼

[lleange]

this is just a start and i hope on the next vids i would learn more! thank you for helping like me stay at home mom

[juliusvincenttolentino]

Thank you for this!

I kept on following your videos Sir, Although you forgot the home button, I already found the code through the comments.


Thank you Very Much!

See you on your next video

[strskt]

best way to remember rows and columns


columns go up and down to support structures


you can only row your boat left and right.

[maredensumpay]

New Learner here, it was very Helpful and I learned I lot.

[theadventurousfeet]

Your teaching is absolutely amazing. Ive understood everything as you go over every smallest detail for even a beginner to learn

[patryk]

Great video.I've just started my "adventure" with a VBA, it would be great to watch more coding vidoes.thanks and all the best.

[robhunter]

I'm impressed. Clear, concise and to the point great tutorials... I'd like to see more of them. I'm chasing a VBA script that will change the internal colour of a  cell within a range if it shows a particular value... like a date... or a name... your explanation gets me close but if you have a particular piece of code it would be appreciated.