vba course Archives - Excel-Help

Dec52020 by excelhelp13No Comments

VBA Excel How To Unhide Rows With If Condition

VBA Range

Open Excel FileClick Alt + F11 Or Click On Developer Tab And Go Visual Basic Application.One Dialog Screen Will Get Open.Click Insert And Add Module.Create Sub Procedure With Any Name.Make Sure The Procedure Name Start With String And Without Space.Write The Code In Between Sub And Sub End.Click Run Button Or Insert A Form Button In Excel Sheet.Any Sub Procedure / Macro Can Be Assign To A Button.Then Goto Visual Basic Editor Prepare Sub Procedure.Sub Unhide_Rows_On_IF_Condition() End SubIn That Procedure Whatever Event You Want To Get Fire You Will Have To Right The Code According To It.In This Example We Will Unhide The Rows With For Loop Against If Condition.If You Want To Re Hide It Use This Code ActiveSheet.Range("F"& i ).Rows.Hidden=TrueNote: Please Use Range & Sheets Name A...

Dec52020 by excelhelp13No Comments

VBA Excel Workbook Open Event

VBA Workbook And Sheets

Open Excel FileClick Alt + F11 Or Click On Developer Tab And Go Visual Basic Application.One Dialog Screen Will Get Open.Click Insert And Add Module.Create Sub Procedure With Any Name.Make Sure The Procedure Name Start With String And Without Space.Write The Code In Between Sub And Sub End.Click Run Button Or Insert A Form Button In Excel Sheet.Any Sub Procedure / Macro Can Be Assign To A Button.Then Goto Visual Basic Editor And Select Thisworkbook And Then Change The Event To Workbook From The Dropdown As Shown In Image.One Sub Procedure Will Automatically Get PreparedPrivate Sub Workbook_Open() End SubIn That Procedure Whatever Event You Want To Get Fire You Will Have To Right The Code According To It.In This Example We Will Delete Hide And Unhide The Rows.That’s It :)Please Check The ...

Dec32020 by excelhelp13No Comments

Introduction To VBA

VBA Introduction

VBA Is A Visual Basic For Application. It's a scripting language to automate the repetitive task but its' not limited to it. Beyond that you can achieve lot's of automation with the help of VBA. You can create Application , Game , Robot Scraper and much more. VBA is a powerful and very much effective when its combine with Excel. Its very easy to understood and easy to apply in real time. So if you don't want to just limit yourself to formulas in excel and want to be a great programmer start your journey with Excel Help.

Dec22020 by excelhelp13No Comments

How To Copy And Paste Data In Different Sheet With VBA

VBA, VBA Range

INTRODUCTION: Range Is Used To Define The Start And End Point For A Particular Selection Of Cells. Examples "A1:A5" or "A1" Etc... Open Excel File Click Alt + F11One Dialog Screen Will Get OpenClick Insert And Add ModuleCreate Sub ProcedureMake Sure The Procedure Name Start With String And Without Space.Write The Code In Between Sub And Sub End Click Run ButtonBy Clicking The Range Data Will Get Select And All Data Will Be Copied And Pasted Automatically On Another Sheet.To Copy The Data Use Range("a1:a5").Copy Sheets(2).Range("a1")To Cut And Paste Data Use Range("a1:a6").Cut Sheets(2).Range("b1")That's It :)Please Check The Images And Video For More Info.

Dec22020 by excelhelp13No Comments

How To Copy And Paste Selected Range Data In VBA

VBA, VBA Range

INTRODUCTION: Range Is Used To Define The Start And End Point For A Particular Selection Of Cells. Examples "A1:A5" or "A1" Etc... Open Excel File Click Alt + F11One Dialog Screen Will Get OpenClick Insert And Add ModuleCreate Sub ProcedureMake Sure The Procedure Name Start With String And Without Space.Write The Code In Between Sub And Sub End Click Run ButtonBy Clicking - All Range Data Will Get Copied And Pasted Automatically To Destination Range.To Copy The Content Use Range("a1:a5").Copy Range("b5:b10")For Cut And Paste Data Use Range("a1:a5").Cut Range("b5:b10")That's It :)Please Check The Images And Video For More Info.

Dec22020 by excelhelp13No Comments

How To Clear Selected Range Data With VBA

VBA, VBA Range

INTRODUCTION: Range Is Used To Define The Start And End Point For A Particular Selection Of Cells. Examples "A1:A5" or "A1" Etc... Open Excel File Click Alt + F11One Dialog Screen Will Get OpenClick Insert And Add ModuleCreate Sub ProcedureMake Sure The Procedure Name Start With String And Without Space.Write The Code In Between Sub And Sub End Click Run ButtonBy Clicking The Range Data Will Get Select And All Data Will Be Deleted Automatically.For Only Content Deletion Use Range("a1:a5").ClearContentsTo Clear All Like Formatting - Data -Etc. Use Range("a1:a5").ClearThat's It :)Please Check The Images And Video For More Info.

Dec12020 by excelhelp13No Comments

How To Populate Range With VBA

VBA, VBA Range

INTRODUCTION: Range Is Used To Define The Start And End Point For A Particular Selection Of Cells. Examples "A1:A5" or "A1" Etc... Open Excel File Click Alt + F11One Dialog Screen Will Get OpenClick Insert And Add ModuleCreate Sub ProcedureMake Sure The Procedure Name Start With String And Without Space.Write The Code In Between Sub And Sub End Click Run ButtonBy Clicking - The Range Will Be Populated Automatically With The Sentence "My First Code". You Can Have Any Words Or Sentence Or Numbers.That's It :)Please Check The Images And Video For More Info.

Dec12020 by excelhelp13No Comments

How To Select RangeWith VBA

VBA, VBA Range

INTRODUCTION: Range Is Used To Define The Start And End Point For A Particular Selection Of Cells. Examples "A1:A5" or "A1" Etc... Open Excel File Click Alt + F11One Dialog Screen Will Get OpenClick Insert And Add ModuleCreate Sub ProcedureMake Sure The Procedure Name Start With String And Without Space.Write The Code In Between Sub And Sub End Click Run ButtonBy Clicking The Range Will Be Select Automatically.That's It :)Please Check The Images And Video For More Info.