excel vba Archives - Page 2 of 3

Dec82020 by excelhelp13No Comments

Orientation In Excel

Definition:- The Orientation Command Can Adjust The Text Vertical And Diagonally By Rotating The Cells Text Clockwise And Counter-Clockwise 90 Degrees. Step 1- Select The Cell You Want To Format And Click On Orientation Button. Step 2 – Select The Option In The Orientation Options As Per Your Requirement And Get The Result. For Example:- Please Check The Image Below.

Dec82020 by excelhelp13No Comments

Alignment In Excel

Home Menu, Menu Bar

Definition:- How The Text Or Number Is Set In The Cell Or How You Want It To Be Set Such As Up, Down, Left, Right Or Middle. This Can Be Done With The Alignment Tool. Alignment Consists Of Two Methods. (1) Horizontal Which Means To The Left, Center Or Right. (2) Vertical Which Means Up, Middle Or Down. Horizontal Alignment Left − Aligns The Cell Contents To The Left Side Of The Cell. Center − Centers The Cell Contents In The Cell. Right − Aligns The Cell Contents To The Right Side Of The Cell. 2.Vertical Alignment − • Top Aligns:- The Cell Contents To The Top Of The Cell.• Center Align:- Centers The Cell Contents Vertically In The Cell.• Bottom Aligns:- The Cell Contents To The Bottom Of The Cell.

Dec82020 by excelhelp13No Comments

How To Fill Color In Excel

Home Menu, Menu Bar

Definition:- Fill Color Is Used To Add A Color To A Background In A Cell / Database.. Step 1- Select The Cell Or Database Range And Then Click On The Fill Color Icon. Step 2- Select The Color You Want To Highlight In The Background Of Your Cell Or Database.

Dec82020 by excelhelp13No Comments

How To Use Borders In Excel

Home Menu, Menu Bar

Definition:- The Border Option Is A Built-In Tool That Provides Border Styles To Border One Or More Cells On A Spreadsheet. You Can Also Use The Borders Tool To Create Your Own Custom Border. Step1 - Select The Cell Or Range That You Want Format And Click On Borders Drop Down Box. Step 2- Choose The Border Style In Borders Drop Down Box That You Want . You Can Also Use The Borders To Draw Borders Tool To Create Your Own Custom Borders.

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 ...

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...

Dec42020 by excelhelp13No Comments

Select Or Activate The Sheet In Excel With VBA

VBA Workbook And Sheets

INTRODUCTION: Worksheets Are Part Of Workbook In Excel Application. Open Excel File Click Alt + F11 Or Click On Developer Tab And Go Visual Basic Application.One Dialog Screen Will Get OpenClick Insert And Add ModuleCreate Sub Procedure With Any NameMake 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 SheetAny Sub Procedure / Macro Can Be Assign To A Button Like This Example To Fire The Event On Clicking The Button.DIFFERENCE := For Example Sheets(1).Range("A1").Select Like This You Can Apply Select Method To Select The Sheet & At the Same Time Range Too. But you Can't Apply This Same Method For Activate That's The Difference Between Select And Activate.That's It :)Please Chec...

Dec42020 by excelhelp13No Comments

Delete Entire Row Or Column In Excel With VBA

VBA Workbook And Sheets

Open Excel File Click Alt + F11 Or Click On Developer Tab And Go Visual Basic Application.One Dialog Screen Will Get OpenClick Insert And Add ModuleCreate Sub Procedure With Any NameMake 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 SheetAny Sub Procedure / Macro Can Be Assign To A Button Like This Example To Fire The Event On Clicking The Button.That's It :)Please Check The Images And Video For More Info.

Dec32020 by excelhelp13No Comments

Copy And Paste Entire Row Or Column In Excel With VBA

VBA Workbook And Sheets

INTRODUCTION: Rows & Columns Are Part Of Workbook & Worksheets In Excel Application. Open Excel File Click Alt + F11 Or Click On Developer Tab And Go Visual Basic Application.One Dialog Screen Will Get OpenClick Insert And Add ModuleCreate Sub Procedure With Any NameMake 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 SheetAny Sub Procedure / Macro Can Be Assign To A Button Like This Example To Fire The Event On Clicking The Button.That's It :)Please Check The Images And Video For More Info.

Dec32020 by excelhelp13No Comments

Close Open Workbook With VBA

VBA Workbook And Sheets

INTRODUCTION: Workbook Is A Part Of Application. Worksheets Is A Part Of Workbook. Open Excel File Click Alt + F11 Or Click On Developer Tab And Go Visual Basic Application.One Dialog Screen Will Get OpenClick Insert And Add ModuleCreate Sub Procedure With Any NameMake 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 SheetAny Sub Procedure / Macro Can Be Assign To A Button Like This Example To Fire The Event On Clicking The Button.That's It :)Please Check The Images And Video For More Info. Insert Button