EXCEL VBA
58 videos • 127 views • by LearnYouAndMe
1
How to record your first excel macro (automate Excel) ?
LearnYouAndMe
Download
2
How To Give Or Change a Macro/Vba Shortcut Key (Create shortcut key to run VBA)
LearnYouAndMe
Download
3
Various ways to run macro or VBA in Excel (creat macro button / create macro shortcut key)
LearnYouAndMe
Download
4
USED RANGE and CURRENT RANGE OR REGION in Excel.[HD]
LearnYouAndMe
Download
5
Excel VBA to INTERACT with RANGE or CELL- PART 1
LearnYouAndMe
Download
6
Excel VBA to INTERACT with RANGE or CELL- PART 2 [HD]
LearnYouAndMe
Download
7
Option Explicit Statement in VBA
LearnYouAndMe
Download
8
Restrict EDITABLE / Entry Range in Excel.
LearnYouAndMe
Download
9
Immediate Window in VBA IDE
LearnYouAndMe
Download
10
Color Related VBA - Part 1
LearnYouAndMe
Download
11
Color Related VBA - Part 2
LearnYouAndMe
Download
12
Cell Blinking or flashing Effect in Excel (Color VBA - Part 3)
LearnYouAndMe
Download
13
VBA LOOP BASIC - PART-1A
LearnYouAndMe
Download
14
VBA LOOP BASIC (For Each Loop) - PART1B
LearnYouAndMe
Download
15
Exit For use in For loop (VBA Loop Basic - PART1C)
LearnYouAndMe
Download
16
Goto Keyword use in VBA or In loop (VBA LOOP BASIC - PART1D)
LearnYouAndMe
Download
17
VBA to auto highlight same group cells (narrow down your range focus) P1 [HD]
LearnYouAndMe
Download
18
VBA to highlight active row or record of a table automatically. [HD]
LearnYouAndMe
Download
19
Insert images in Excel cells (multiple images insertion and auto-resize/fit in cell)
LearnYouAndMe
Download
20
Build Simple Counter using VBA.
LearnYouAndMe
Download
21
Create Custom / User Defined Functions or UDF in Excel using VBA.
LearnYouAndMe
Download
22
UDF formula to get cell comment text.
LearnYouAndMe
Download
23
Join or Concatenate String in VBA
LearnYouAndMe
Download
24
Offset property of range in Excel VBA (Derive new range from a given range)
LearnYouAndMe
Download
25
Vlookup to return duplicate values or vlookup (UDF) duplicate values in Excel - Method 2
LearnYouAndMe
Download
26
Automate line formatting or colouring in a text in a single Excel cell
LearnYouAndMe
Download
27
Automate line formatting or colouring in a text in a single Excel cell
LearnYouAndMe
Download
28
Prevent uppercase and lowercase entry in Excel | Auto capitalize, auto small letter entry in Excel
LearnYouAndMe
Download
29
Prevent uppercase and lowercase entry in Excel | Auto capitalize, auto small letter entry in Excel
LearnYouAndMe
Download
30
Prevent uppercase and lowercase entry in Excel | Auto capitalize, auto small letter entry in Excel
LearnYouAndMe
Download
31
Prevent uppercase and lowercase entry in Excel | Auto capitalize, auto small letter entry in Excel
LearnYouAndMe
Download
32
Abbreviation Function In Excel (VBA UDF for Short form | Abbreviation | Acronym)
LearnYouAndMe
Download
33
Convert Numbers/currency to Words (Rs, Dollar, Any currency) formula in Excel | Excel Spell number
LearnYouAndMe
Download
34
Convert number to Hindi words in Excel / Spell number in Hindi / Devnagari words in Excel
LearnYouAndMe
Download
35
Enable or show developer tab in Excel (Hindi Speech) | एक्सेल में डेवलपर टैब एक्टिवेट करे
LearnYouAndMe
Download
36
Full view Excel screen | Maximize Excel window area
LearnYouAndMe
Download
37
Highlight active cell automatically without erasing past cell colour in Excel (Method-2)
LearnYouAndMe
Download
38
Automatically refresh Pivot Table after updating data source
LearnYouAndMe
Download
39
Excel VBA private sub and public sub (private vs public sub in VBA)
LearnYouAndMe
Download
40
Highlight and hyperlink a record dynamically Excel application (Hindi speech)
LearnYouAndMe
Download
41
Email Extractor Pro tutorial | Extract mailid utility
LearnYouAndMe
Download
42
Vlookup to return multiple values in one cell In Excel ( 3 Methods) | TextJoin If
LearnYouAndMe
Download
43
Case sensitive Vlookup (lookup) in Excel | Exact match lookup in Excel
LearnYouAndMe
Download
44
Change gridline | grid color in Excel sheet (using settings and using VBA)
LearnYouAndMe
Download
45
Split multiple lines in a cell into separate Cells/rows/columns (2 ways)
LearnYouAndMe
Download
46
How to count unique values in Excel (count unique or distinct occurrences -2 ways)
LearnYouAndMe
Download
47
Count number of words in a cell in Excel (word count in a text)
LearnYouAndMe
Download
48
How to count specific word in a text in Excel | count specific characters in a cell
LearnYouAndMe
Download
49
Excel VBA ByVal and ByRef difference | Passing argument by ByRef in VBA
LearnYouAndMe
Download
50
How to lock or protect cells after data entry in Excel? | Auto protect cell after edition in Excel
LearnYouAndMe
Download
51
How to use Excel VBA WITH keyword | WITH keyword in VBA | VBA WITH block code
LearnYouAndMe
Download
52
What is Option Compare Text in Excel VBA? | Case insensitive VBA if #ExcelVBA #excel
LearnYouAndMe
Download
53
What is worksheet code name and why to use in VBA? (VBA best practices)
LearnYouAndMe
Download
54
Excel VBA to write in Cell or Range ( VBA to fill range with value) #excelVBA
LearnYouAndMe
Download
55
Excel Trick | Do smart work : Quickly Unhide multiple sheets in Excel #msExcel
LearnYouAndMe
Download
56
Crows In Concert - 5 Minutes Of Crow Sounds - ⚠️Warning: Loud! ⚠️
Corvus Aeternus
Download
57
Faster Than We Thought Possible - Nobel Prize in Physics 2023 Explained
Science Discussed
Download
58
Beginner Power BI DAX Functions Tutorial [Full Course]
Pragmatic Works
Download