Articles about
VBA Functions

Mostly descriptive content covering VBA various functions and subroutines

Other Categories

VBA Topics
•
Dragon Scripting
•
VBA Classes
•
VBA Basics
•
Word Commands
•
Word Macros
•
Text Expansion
•
All

Latest

VBA Functions

Article

VBA Functions
Word • Macros • Basics • Functions

Introduction to functions and subroutines

We introduce functions and subroutines in Word VBA explaining the basic concepts and how to use them.
July 30, 2025
•
54
min read

All

VBA Functions

Articles

VBA Functions
Word • Macros • Editing • Functions

Get any sentence range

Create a function to get a sentence range while allowing for dialog or parentheses
July 10, 2025
•
39
min read
VBA Functions
Word • Macros • Functions

Get the next character range

Create a function to return the intuitive next character after a range
June 28, 2025
•
16
min read
VBA Functions
Word • Macros • Editing • Functions

Get a sentence range allowing some dialog

Create a function to get a sentence range while allowing for some dialog or parentheses
July 23, 2025
•
32
min read
VBA Functions
Word • Macros • Functions

Trim a character from a range

Create a function to trim characters from either end of a range
July 23, 2025
•
17
min read
VBA Functions
Word • Macros • Editing • Functions

Delete range end spaces

Create a function to delete spaces at the end of a given range
June 28, 2025
•
25
min read
VBA Functions
Word • Functions

Check whether a range is empty

Check whether a range is empty
July 23, 2025
•
20
min read
VBA Functions
Word • Functions

Check whether a paragraph is empty

Check whether a given paragraph is empty
April 25, 2025
•
24
min read
VBA Functions
Word • Macros • Functions • Organization

Get main function key from shortcut text

Get the key constant corresponding to a text function key
September 24, 2024
•
18
min read
VBA Functions
Word • Macros • Functions • Organization

Get main key from shortcut text

Get the key constant corresponding to an alphanumeric character
September 24, 2024
•
15
min read
VBA Functions
Word • Macros • Functions • Organization

Key check for main key bindings

Detect whether a key is a valid shortcut key by itself
September 17, 2024
•
24
min read
VBA Functions
Word • Macros • Functions • Organization

Key check for isolated key bindings (clumsy)

Detect whether a key is a valid shortcut key by itself
September 17, 2024
•
16
min read
VBA Functions
Word • Macros • Functions • Organization

Get keycode function improved

Get a unique keycode for any keyboard shortcut combination including enhancements
September 20, 2024
•
48
min read
VBA Functions
Word • Macros • Functions • Organization

Get keycode function

Get a unique keycode for any keyboard shortcut combination
September 17, 2024
•
33
min read
VBA Functions
Word • Macros • Functions • Editing

Toggle paragraph styles more

Create a function to toggle between styles for a given paragraph
August 2, 2024
•
19
min read
VBA Functions
Word • Macros • Functions

Search for paragraph styles

Create a function to find the nearest paragraph with a given style
May 26, 2025
•
19
min read
VBA Functions
Word • Macros • Functions

Move multiple paragraphs

Create a VBA function to move paragraphs up or down in a Microsoft Word document
June 19, 2024
•
28
min read
VBA Functions
Word • Macros • Functions

Toggle characters around range

Implement a function to toggle individual characters around a given range
July 17, 2024
•
18
min read
VBA Functions
Word • Macros • Functions

Toggle quotes around Range

Implement a function to toggle double quotes around a range
July 17, 2024
•
16
min read
VBA Functions
Word • Macros • Functions

Trim blank space from range

Implement a function to trim excess blank space from a range
April 18, 2024
•
9
min read
VBA Functions
Word • Macros • Functions

Detect punctuation mark type

Create a quick function to detect punctuation mark categories
April 11, 2024
•
10
min read
VBA Functions
Word • Macros • Functions

Range intersection

Create a function to find the intersection of two ranges
April 11, 2024
•
10
min read
VBA Functions
Word • Macros • Editing • Functions

Disable screen updates

Quick subroutines to toggle screen updates and options for macros
May 8, 2024
•
6
min read
VBA Functions
Word • Macros • Functions

Validate styles

Create a function to check whether a given style exists
April 11, 2024
•
12
min read
VBA Functions
Word • Macros • Editing • Functions

Delete range forced

Create a function to delete a given range without allowing Word to automatically adjust the spacing
April 11, 2024
•
10
min read
VBA Functions
Word • Macros • Editing • Functions

Get the current sentence range

Create a function to get the current sentence range while allowing for dialog or parentheses
July 10, 2025
•
28
min read
VBA Functions
Word • Macros • Functions

Double quote functions (original)

Create functions to return the correct double characters regardless of the operating system
June 28, 2025
•
5
min read
VBA Functions
Word • Macros • Editing • Functions

Delete empty paragraph

Create a function to detect and delete an empty paragraph
April 11, 2024
•
15
min read
VBA Functions
Word • Macros • Functions

Get the next character text

Create a function to return the intuitive next character text after a range
June 28, 2025
•
11
min read
VBA Functions
Word • Macros • Editing • Functions

Correct sentence spacing

Create a function to ensure correct spacing around a given range
July 3, 2025
•
18
min read
VBA Functions
Word • Macros • Editing • Functions

Delete paragraph end spaces

Create a function to delete spaces at the end of a paragraph
June 28, 2025
•
22
min read
VBA Functions
Word • Macros • Basics • Functions

Introduction to functions and subroutines

Brief introduction to functions and subroutines
July 30, 2025
•
54
min read