pctechguide.com

  • Home
  • Guides
  • Tutorials
  • Articles
  • Reviews
  • Glossary
  • Contact

VBA Macro to See Boy and Girl Names with a Given Letter

Are you looking for a VBA macro that will tell you what names start with a given letter? We came up with one for you!

This macro will prompt you for a letter and then share a list of boy names and a separate list of girl names with that letter. Here is a screenshot of it asking for the letter:

And here is the output after you enter the letter “a”:

The code is listed below. You can obviously add more names to the array. I tried adding the 1,000 most common boy names and 1,000 most common girl names. However, it is a tedious process to add them all at once, because you get an error that there are too many line continuations if you try to copy and paste them in the array at one time. However, if you are ambitious, you can create a very large list with them all.

Sub ShowNamesByLetter()
‘ Define arrays for boy and girl names
Dim boyNames As Variant
Dim girlNames As Variant

boyNames = Array("Aaron", "Abel", "Adam", "Adrian", "Aiden", "Alexander", "Andrew", "Anthony", "Arthur", "Asher", _
                 "Benjamin", "Blake", "Brandon", "Brian", "Bryce", "Caleb", "Cameron", "Carter", "Charles", "Christian", _
                 "Christopher", "Connor", "Daniel", "David", "Dominic", "Dylan", "Elijah", "Elliot", "Ethan", "Evan", _
                 "Gabriel", "Gavin", "George", "Grayson", "Henry", "Hudson", "Hunter", "Isaac", "Isaiah", "Jack", _
                 "Jackson", "Jacob", "James", "Jayden", "John", "Jonathan", "Joseph", "Joshua", "Julian", "Justin", _
                 "Kevin", "Landon", "Liam", "Logan", "Lucas", "Luke", "Mason", "Matthew", "Michael", "Nathan", _
                 "Nathaniel", "Nicholas", "Noah", "Oliver", "Owen", "Patrick", "Paul", "Peter", "Quentin", "Ryan", _
                 "Samuel", "Sebastian", "Thomas", "Tyler", "William", "Wyatt", "Zachary")

girlNames = Array("Abigail", "Addison", "Adeline", "Alexa", "Alice", "Alyssa", "Amelia", "Anna", "Aria", "Ariana", _
                  "Aubrey", "Ava", "Bella", "Brianna", "Brooke", "Camila", "Caroline", "Charlotte", "Chloe", "Claire", _
                  "Clara", "Daisy", "Delilah", "Ella", "Ellie", "Emily", "Emma", "Eva", "Evelyn", "Faith", _
                  "Gabriella", "Grace", "Hannah", "Harper", "Hazel", "Isabella", "Isabelle", "Jasmine", "Julia", "Katherine", _
                  "Kayla", "Layla", "Leah", "Lillian", "Lily", "Lucy", "Madeline", "Madison", "Maya", "Mia", _
                  "Natalie", "Nora", "Olivia", "Penelope", "Peyton", "Quinn", "Riley", "Samantha", "Sarah", "Savannah", _
                  "Scarlett", "Sophia", "Sophie", "Stella", "Taylor", "Victoria", "Violet", "Zoe", "Zoey")

' Prompt user for a letter
Dim inputLetter As String
inputLetter = InputBox("Please enter a letter:", "Enter Letter")

' Check if input is a single letter
If Len(inputLetter) <> 1 Or Not inputLetter Like "[A-Za-z]" Then
    MsgBox "Please enter a single letter.", vbExclamation, "Invalid Input"
    Exit Sub
End If

' Convert input to uppercase for case-insensitive comparison
inputLetter = UCase(inputLetter)

' Find matching names
Dim matchingBoyNames As String
Dim matchingGirlNames As String
matchingBoyNames = ""
matchingGirlNames = ""

Dim name As Variant

For Each name In boyNames
    If Left(UCase(name), 1) = inputLetter Then
        matchingBoyNames = matchingBoyNames & name & vbCrLf
    End If
Next name

For Each name In girlNames
    If Left(UCase(name), 1) = inputLetter Then
        matchingGirlNames = matchingGirlNames & name & vbCrLf
    End If
Next name

' Display results
If matchingBoyNames = "" And matchingGirlNames = "" Then
    MsgBox "No names found starting with the letter " & inputLetter & ".", vbInformation, "No Matches"
Else
    Dim result As String
    result = "Boy Names:" & vbCrLf & matchingBoyNames & vbCrLf & "Girl Names:" & vbCrLf & matchingGirlNames
    MsgBox result, vbInformation, "Names Starting with " & inputLetter
End If

End Sub

We hope you enjoy this macro!

Filed Under: Articles

Latest Articles

Illustrated Intel Centrino Duo technology guide

In January 2006, Intel introduced the revolutionary Intel Centrino Duo Mobile Technology platform (formerly codenamed Napa), the third generation of the company's Centrino mobile processor technology bundle. Facilitating a whole new generation of thin and light notebook PCs, the following three next … [Read More...]

OSI Model

The Open Systems Interconnection (OSI) reference model describes how information from a software application in one computer moves through a network medium to a software application in another computer. The OSI reference model is a conceptual … [Read More...]

How to Charge Your iPhone Faster

Yes it is a First World problem, but it is very frustrating to find your iPhone dead when you are getting ready to go out. You may see that dreaded red bar on your iphone and come to the realization that you have less than 20% of power and are going to be away from a charging station for a long … [Read More...]

Why Internet Bundles Are the Next Battleground for Gamers

A weak internet connection can turn seamless gaming sessions into frustrating experiences filled with lag, buffering or sudden disconnects. For … [Read More...]

Importance of Inbound Marketing in the Digital Age

A couple of months ago, Zacks reported that Hubspot was starting to make some major changes to its inbound marketing strategy. They talk a lot about … [Read More...]

Damage Control Strategies for Resolving Online PR Crises

Last July, Astrologer faced a major crisis after its CEO went viral at a ColdPlay concert when having an affair. This was just one of the many times a … [Read More...]

AI is Not Killing Computer Jobs Like Doomers Projected

There is no denying the reality that AI technology has played a massive role in disrupting our lives. A growing number of people claim that AI … [Read More...]

Everything You Need to Know About Sourcing Circuit Boards From U.S. Suppliers

In This Article This article includes: Why Source PCBs From the United States?How to Get a Quote From a U.S.-Based PCB ManufacturerThe Top U.S. … [Read More...]

Top Taplio Alternatives in 2025 : Why MagicPost Leads for LinkedIn Posting ?

LinkedIn has become a strong platform for professionals, creators, and businesses to establish authority, grow networks, and elicit engagement. Simple … [Read More...]

Guides

  • Computer Communications
  • Mobile Computing
  • PC Components
  • PC Data Storage
  • PC Input-Output
  • PC Multimedia
  • Processors (CPUs)

Recent Posts

Monitor Technologies: Slotted Mask

Capitalising on the advantages of both the shadow mask and aperture grill approaches, NEC has developed a hybrid mask type which uses a slot-mask … [Read More...]

Container vs VM: What Is the Difference and Which One to Pick?

VMs and containers are two implementations of virtualization technology. This means that both VMs and  containers help to optimize how resources … [Read More...]

Cabling

In 1985, the Computer Communications Industry Association (CCIA) requested the Electronic Industries Association (EIA) … [Read More...]

[footer_backtotop]

Copyright © 2026 About | Privacy | Contact Information | Wrtie For Us | Disclaimer | Copyright License | Authors