Excel VBA Introduction Part 1 - Getting Started in the VB Editor
Why Stack Overflow recommends it
Stack Overflow users link it when answering newcomers to VBA, pointing them to the whole Excel VBA Introduction series as a structured starting point.
Recommended by 3 people across 11 different months, 2016 to 2024.
What it is
A 13-minute beginner tutorial from WiseOwlTutorials, presented by Andrew Gould, on using the Visual Basic Editor in Excel. It covers opening the editor in different Excel versions, navigating and docking windows, creating, removing and renaming modules, and setting fonts. No code is written; it is the first part of a long Excel VBA introduction series.
What people said
Strong rec TinMan · 2024-12 · Stack Overflow · on “Code for making all fields on a UserForm required to be filled in before form submission”
@Tee Watch: Excel VBA Introduction Part 1 - Getting Started in the VB Editor [this video] and Excel VBA Introduction Part 21 - User Forms [LINK] . IMO, this is the best tutorial series on YouTube.
Recommends user6432984 · 2016-07 · Stack Overflow · on “Automatically Generate CSVs based on cell data”
Lol. You had the right idea but you get caught up in thinking that you had to collect all the data for each file and write it all at one time before moving on to the next file. You forgot that you were appending and could close the file and reopen it later. You should watch TheWiseOwlTutorials [this video] on Youtube.
Recommends user6432984 · 2017-08 · Stack Overflow · on “VBA Macro Loop Display Value in specific column”
YOu should watch this series on Youtube: Excel VBA Introduction [this video] . This one is relevant: Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset) [LINK]
Recommends user6432984 · 2017-12 · Stack Overflow · on “Excel Limit Cell Input Based On Other Cell's Selection and Work Down Column”
If you are looking for a VBA solution then start watching this series: Excel VBA Introduction Part 1 - Getting Started in the VB Editor [this video] . It sounds like you want to setup data validation rules. Here is a list of 44 videos from ExcelIsFun on data validation: ExcelIsFun [LINK]
Recommends TinMan · 2018-12 · Stack Overflow · on “How to reference cell "A(x.Value)" where x is an Integer that goes from 1 until "A(x.Value)" = NULL”
Integers are not Objects in VBA. If Workbooks("Training_TEST").Sheets(2).Range("A" & x) = Null Then You should watch Excel VBA Introduction [this video] video series on YouTube. Here are some relevant videos: Excel VBA Introduction Part 8 - Variables [LINK] Excel VBA Introduction Part 9 - Object Variables [LINK] Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset) [LINK]
Recommends Stefani · 2020-03 · Stack Overflow · on “VBA: type mismatch error on finding elements from another list”
thank you so much, was the way i was trying to solve it wrong? Is there any channel you recommend for learning? I am new to VBA and i am checking the tutorials in the link below: [this video] Note: not sure if referring youtube videos is permitted here, if not please inform me so i delete it. Thank you a lot
Recommends TinMan · 2020-07 · Stack Overflow · on “Multi-selection values from ListBox to paste in different cells in another sheet”
You say that your new to VBA. Are you using RubberDuck [LINK] ? You should watch this series Excel VBA Introduction Part 1 - Getting Started in the VB Editor [this video] on YouTube.
Recommends TinMan · 2020-08 · Stack Overflow · on “Excel VBA finding the upper and lower bound of a number automatically”
You should work through this series till you can solve your question: Excel VBA Introduction Part 1 - Getting Started in the VB Editor [this video]
Recommends TinMan · 2020-11 · Stack Overflow · on “Is there a way to reference another cell in a range while iterating through a FOR EACH loop in VBA?”
As Dean mentioned, it would be easier to use nested For Next loops. Judging from the Results, I don't think your code is doing what you want it to do. Markers Results Test Public Function wsFlightBoardPage1() As Worksheet Set wsFlightBoardPage1 = ThisWorkbook.Worksheets("Flight Board - Page 1") End Function Public Sub ShiftCells() Dim c As Long Dim r As Long Dim Count As Long Dim Target As Range, Source As Range With wsFlightBoardPage1 For r = 3 To 33 Step 10 For c = 3 To 31 Step 4 Set Target = .Cells(r, c) Set Source = Target.Offset(1).Resize(7) If Len(Target.Value) = 0 And Len(Source.Cells(1, 1).Value) > 0 Then Source.Copy Destination:=Target Target.Resize(7).ClearContents End If Next Next
Recommends TinMan · 2023-11 · Stack Overflow · on “Issue with buttons and textboxes”
You should watch teh Excel VBA Introduction [this video] on YouTube. My code used the default CommandButton names. The event names must match the control names. See Excel VBA Introduction Part 20.1 - Event Procedures [LINK]