Beginner Introduction To Variables In Excel VBA - Excel VBA Beginner Fundamentals (3/6)
If you’re a beginner in Excel VBA, you may be wondering: What’s An Excel VBA Variable?
📊DOWNLOAD COURSE HANDBOOK / EXCEL FILES
https://tinyurl.com/hf6rw89f
Excel, like computer programming more generally, is full of terms that are difficult to understand. I’ve often said, for example, that the OFFSET formula should be renamed ‘MOVE AWAY FROM’. So, what about a ‘variable’? Does it ‘vary’ in some way? Well, kind of. But, as you might expect, its function cannot be easily understood from its name. It’s a shame because variables in Excel VBA are one of the building blocks of powerful Excel applications.
🔥Excel VBA Beginner Fundamentals Playlist
https://tinyurl.com/rj4b3ayx
I’m offering you a simple definition today: a variable is a place to store information. In this way, it can be compared to a cell in the spreadsheet – we are very used to inputting data there! So, why do you need variables? Well, unlike cells, variables live in VBA and are only ‘seen’ if we specifically ask to externlise their value for some reason (for example, by using a message box, as we do in the video.) This means they can be more efficient and easier to control - variables drive all the ‘slick’ Excel VBA applications I have developed over the years.
But, you’ve got plenty of time to get to the more powerful applications later. In this video, I take you through variables from an absolute beginner perspective. We explore the concept of a variable (look out for the ‘mic pack’!), create three variables in Excel VBA, then pass data to them and use them to perform a simple operation. In the final step, we see how variables can ‘read’ and ‘write’ data to the spreadsheet. In this sense, they facilitate a thing of beauty and a feature of many powerful Excel applications: interaction between the spreadsheet and the VBA editor.
ABOUT THE EXCEL VBA BUILDING BLOCKS COURSE
📊DOWNLOAD COURSE HANDBOOK / EXCEL FILES
https://tinyurl.com/hf6rw89f
Learn the fundamentals of Excel VBA in around an hour with Tiger's FREE Excel VBA Building Blocks course. The course is based on Chris' 10 years of Excel training, consultancy and content creation, and teaches the basics of Excel VBA around 18 simple ideas or 'building blocks'. In addition to the 6 basic videos on Excel VBA, on the website you can find 3 'metaskill' videos (to be uploaded through Summer 2021) about next level concepts that could unlock your potential with Excel VBA.
A course handbook is provided for free that lists each of the Excel VBA beginner building blocks and includes a learning template for each session - make sure you download and use it to support your learning.
Use the link below to download the course handbook and access the learning template for this session.
📊DOWNLOAD COURSE HANDBOOK / EXCEL FILES
https://tinyurl.com/hf6rw89f
Видео Beginner Introduction To Variables In Excel VBA - Excel VBA Beginner Fundamentals (3/6) канала Tiger Spreadsheet Solutions
📊DOWNLOAD COURSE HANDBOOK / EXCEL FILES
https://tinyurl.com/hf6rw89f
Excel, like computer programming more generally, is full of terms that are difficult to understand. I’ve often said, for example, that the OFFSET formula should be renamed ‘MOVE AWAY FROM’. So, what about a ‘variable’? Does it ‘vary’ in some way? Well, kind of. But, as you might expect, its function cannot be easily understood from its name. It’s a shame because variables in Excel VBA are one of the building blocks of powerful Excel applications.
🔥Excel VBA Beginner Fundamentals Playlist
https://tinyurl.com/rj4b3ayx
I’m offering you a simple definition today: a variable is a place to store information. In this way, it can be compared to a cell in the spreadsheet – we are very used to inputting data there! So, why do you need variables? Well, unlike cells, variables live in VBA and are only ‘seen’ if we specifically ask to externlise their value for some reason (for example, by using a message box, as we do in the video.) This means they can be more efficient and easier to control - variables drive all the ‘slick’ Excel VBA applications I have developed over the years.
But, you’ve got plenty of time to get to the more powerful applications later. In this video, I take you through variables from an absolute beginner perspective. We explore the concept of a variable (look out for the ‘mic pack’!), create three variables in Excel VBA, then pass data to them and use them to perform a simple operation. In the final step, we see how variables can ‘read’ and ‘write’ data to the spreadsheet. In this sense, they facilitate a thing of beauty and a feature of many powerful Excel applications: interaction between the spreadsheet and the VBA editor.
ABOUT THE EXCEL VBA BUILDING BLOCKS COURSE
📊DOWNLOAD COURSE HANDBOOK / EXCEL FILES
https://tinyurl.com/hf6rw89f
Learn the fundamentals of Excel VBA in around an hour with Tiger's FREE Excel VBA Building Blocks course. The course is based on Chris' 10 years of Excel training, consultancy and content creation, and teaches the basics of Excel VBA around 18 simple ideas or 'building blocks'. In addition to the 6 basic videos on Excel VBA, on the website you can find 3 'metaskill' videos (to be uploaded through Summer 2021) about next level concepts that could unlock your potential with Excel VBA.
A course handbook is provided for free that lists each of the Excel VBA beginner building blocks and includes a learning template for each session - make sure you download and use it to support your learning.
Use the link below to download the course handbook and access the learning template for this session.
📊DOWNLOAD COURSE HANDBOOK / EXCEL FILES
https://tinyurl.com/hf6rw89f
Видео Beginner Introduction To Variables In Excel VBA - Excel VBA Beginner Fundamentals (3/6) канала Tiger Spreadsheet Solutions
Показать
Комментарии отсутствуют
Информация о видео
13 июля 2021 г. 21:00:46
00:10:26
Другие видео канала
7 Excel VBA Beginner Techniques: Planning and ConceptualisationThe Concept Of The Normal Distribution Explained (Normal Distribution In Excel Part 1)Tiger Live #2 Excel VBA to Collate Data from Multiple Files // Begins 28:385 ESSENTIAL Excel VBA Beginner Techniques#2 - World Cup Daily Spreadsheet Show - Using Excel To Analyse Today's World Cup Fixtures(20/30) Excel VBA Absolute Beginner Course (30 For 30)Re-Launch Party (WITH MEMBERSHIP GIVEAWAY!): Members Monday – Your Excel Learning Community3 Excel Techniques Football Traders Should Know#10 - World Cup Daily Spreadsheet Show - Using Excel To Analyse Today's World Cup Fixtures(11/14) The 3 Seasons Of Your Excel Career - Are You Ready To Move To The Next Level?Excel Tutorial: The Countif FormulaConvert Minutes to Decimals - Excel VBA Beginner Lecture7 Essential Excel VBA Beginner TechniquesHow To Categorise Numbers In Excel Using VLOOKUP6 Reasons Why Excel Is Here To Stay#4 - World Cup Daily Spreadsheet Show - Using Excel To Analyse Today's World Cup FixturesHow To Do What VLOOKUP Can't Do With OFFSET and MATCH(24/30) Excel VBA For Beginners: 30 Real World Problems And Solutions#5 - World Cup Daily Spreadsheet Show - Using Excel To Analyse Today's World Cup FixturesHow To Use Excel VBA Code Real Example S2 P1(23/30) Excel VBA For Beginners: 30 Real World Problems And Solutions