Melanie Jenkins, Author at Software Solutions Online VBA and VB.Net Tutorials, Education and Programming Services

All posts by Melanie Jenkins

Using VBA Sum and VBA Sum Range

The Sum function in Excel is one of the most widely used functions, and in fact, probably one of the first functions that an Excel user learns when they are learning to use Excel! Simply stated, the Sum function adds up a range of cells for

VBA vs. VB.Net — What’s the Difference?

VBA is the programming language behind Microsoft Office. It is derived from a programming language called Basic. VB (Visual Basic) is also derived from Basic. For nearly all programming purposes, they are the same language. VB can either refer to straight Visual Basic (the last version

How Do You Fix an Automation Error in VBA?

One of the more frustrating errors to occur in VBA is the Automation Error. It can often pop up for no apparent reason despite your code looking perfect. Reasons for This Error There are a variety of reasons that this can occur. Microsoft Office is

Using the VLookup Function in VBA

The VLookup function is an Excel function. It can be used directly on your worksheet without having to use any VBA code. However, there may be instances in VBA where you wish to also use VLookup functionality. You would then need to call the VLookup

The Instr and InstrRev Functions in VBA — Checking String Contents

The Instr function in VBA checks to see if a string is contained within another string. This can be useful when trying to extract information from strings of data contained in Excel cells, for example. Instr Syntax The Instr function is made up of 4

The ReDim Statement in VBA

The ReDim statement is used to declare the size of a Dynamic array in VBA. It can later be used to re-declare the size of the array as many times as you need. It can only be used for Dynamic VBA Arrays (where the size

Using the UCase Function in Excel VBA

There may be a time in Excel that you need data that you are fetching from an Excel spreadsheet or importing from external data to be amended to upper case. This can, of course, be done manually, but if it is a large amount of

On Error…Go To: Error Handling in VBA

Even when your code is perfectly constructed, the user might not always do what you would expect. For this reason, you need to insert error handlers into your code whenever there might be a reason that an error might occur. Handling an error when incorrect

How to Use the VBA Replace Function

The VBA Replace function is a function which you can use in your code to replace one set of string characters with another set of string characters, or to replace a set of string characters with an empty string. For example, you may have a

What is a VBA Variant? And Why Would You Ever Use One?

A VBA Variant is a VBA variable that has not been declared to have a specific data type. It can therefore hold any type of data that VBA variables are able to hold – be it text, numbers, dates, time or objects. Variants use more

More To Explore

Home

privacy policy



Melanie Jenkins, Author at Software Solutions Online VBA and VB.Net Tutorials, Education and Programming Services

Recent Posts Excel Use Any Formula: Worksheetfunction in VBA 0 Comments VBA Inserting Rows in VBA: 6 Methods to Try 0 Comments GUI How to Use VBA Input Boxes, With Examples 0 Comments Statements The Right Way to Use the Goto Statement in VBA 0 Comments Excel How to Delete Rows Using VBA 0 Comments Popular Posts 1 File and Folders Find and List all Files and Folders in a Directory 43 Comments 2 Excel Excel VBA, Find and List All Files in a Directory and its Subdirectories 33 Comments 3 Excel VBA Excel, Writing to a Text File 26 Comments 4 Excel Excel VBA Open File Dialog 25 Comments 5 Excel List All Files in a Folder and Create Hyperlinks to Each File, Excel VBA 23 Comments 6 Automation VBA Word, Split Word File into Multiple Files (Every X Pages) 18 Comments 7 Data Validation Excel VBA Drop Down Lists Using Data Validation 18 Comments 8 Excel Excel VBA, Save Range/Cells as JPEG 17 Comments Tags Access alignment Api Arrays Automation Color Create Custom Formatting Database Date Delete Download Earth Error Excel Field FIle Fill Font Formatting Forms Formulas Functions Get Google Gradient IF Insert Mail Merge Open Range Recordset Remove Sample Sample Code Strings Table Tables Tekla TeklaOpenAPI VB.Net VBA VBA For Excel Word	All posts by Melanie Jenkins About the author Melanie Jenkins Melanie Jenkins has been designing databases using Microsoft Access, SQL, VB and VBA for the past 23 years. In addition, Melanie is a certified Microsoft MOS instructor and teaches all levels of the Microsoft office, specialising in advanced Excel, Access and VBA training. Melanie has also written many technical and user training manuals to accompany both the software she has designed and the training courses that she teaches. Using VBA Sum and VBA Sum Range The Sum function in Excel is one of the most widely used functions, and in fact, probably one of the first functions that an Excel user learns when they are learning to use Excel! Simply stated, the Sum function adds up a range of cells for Aug 31, 2020by Melanie Jenkins in Excel VBA vs. VB.Net — What’s the Difference? VBA is the programming language behind Microsoft Office. It is derived from a programming language called Basic. VB (Visual Basic) is also derived from Basic. For nearly all programming purposes, they are the same language. VB can either refer to straight Visual Basic (the last version Aug 28, 2020by Melanie Jenkins in VB.Net How Do You Fix an Automation Error in VBA? One of the more frustrating errors to occur in VBA is the Automation Error. It can often pop up for no apparent reason despite your code looking perfect. Reasons for This Error There are a variety of reasons that this can occur. Microsoft Office is Aug 25, 2020by Melanie Jenkins in Automation Using the VLookup Function in VBA The VLookup function is an Excel function. It can be used directly on your worksheet without having to use any VBA code. However, there may be instances in VBA where you wish to also use VLookup functionality. You would then need to call the VLookup Aug 21, 2020by Melanie Jenkins in Excel The Instr and InstrRev Functions in VBA — Checking String Contents The Instr function in VBA checks to see if a string is contained within another string. This can be useful when trying to extract information from strings of data contained in Excel cells, for example. Instr Syntax The Instr function is made up of 4 Aug 21, 2020by Melanie Jenkins in Functions The ReDim Statement in VBA The ReDim statement is used to declare the size of a Dynamic array in VBA. It can later be used to re-declare the size of the array as many times as you need. It can only be used for Dynamic VBA Arrays (where the size Aug 19, 2020by Melanie Jenkins in Arrays Using the UCase Function in Excel VBA There may be a time in Excel that you need data that you are fetching from an Excel spreadsheet or importing from external data to be amended to upper case. This can, of course, be done manually, but if it is a large amount of Aug 13, 2020by Melanie Jenkins in Excel On Error…Go To: Error Handling in VBA Even when your code is perfectly constructed, the user might not always do what you would expect. For this reason, you need to insert error handlers into your code whenever there might be a reason that an error might occur. Handling an error when incorrect Aug 13, 2020by Melanie Jenkins in Error How to Use the VBA Replace Function The VBA Replace function is a function which you can use in your code to replace one set of string characters with another set of string characters, or to replace a set of string characters with an empty string. For example, you may have a Aug 07, 2020by Melanie Jenkins in Functions What is a VBA Variant? And Why Would You Ever Use One? A VBA Variant is a VBA variable that has not been declared to have a specific data type. It can therefore hold any type of data that VBA variables are able to hold – be it text, numbers, dates, time or objects. Variants use more Aug 06, 2020by Melanie Jenkins in Data Types 1 2 Next → Software-Solutions-Online.com Copyright 2020 Software-Solutions-Online.com. All rights reserved. More To Explore Home
privacy policy