pctechguide.com

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

VBA Macro that Randomly Shows a Boy’s Name in Column A

Are you trying to come up with a boy’s name at random? There may be a number of reasons that you want to do this. you may be writing a book for example, and don’t want to keep thinking about the same names for all of your characters.

The good news is that there is a way to do this with VBA. We created the following macro that randomly chooses a boy’s name from a list of the 300 most common boy’s names in the United States.

You will need to copy the code below in the VBA Editor and click the “Run” button. We have some other primers on how to do that on this site.

Here is the macro.

Sub RandomName()
Dim namesList As Variant
Dim lastRow As Long
Dim randomIndex As Integer

' Define the list of names
namesList = Split("Liam Noah Oliver James Elijah William Henry Lucas Benjamin Theodore Mateo Levi Sebastian Daniel Jack Michael Alexander Owen Asher Samuel Ethan Leo Jackson Mason Ezra John Hudson Luca Aiden Joseph David Jacob Logan Luke Julian Gabriel Grayson Wyatt Matthew Maverick Dylan Isaac Elias Anthony Thomas Jayden Carter Santiago Ezekiel Charles Josiah Caleb Cooper Lincoln Miles Christopher Nathan Isaiah Kai Joshua Andrew Angel Adrian Cameron Nolan Waylon Jaxon Roman Eli Wesley Aaron Ian Christian Ryan Leonardo Brooks Axel Walker Jonathan Easton Everett Weston Bennett Robert Jameson Landon Silas Jose Beau Micah Colton Jordan Jeremiah Parker Greyson Rowan Adam Nicholas Theo Xavier Hunter Dominic Jace Gael River Thiago Kayden Damian August Carson Austin Myles Amir Declan Emmett Ryder Luka Connor Jaxson Milo Enzo Giovanni Vincent Diego Luis Archer Harrison Kingston Atlas Jasper Sawyer Legend Lorenzo Evan Jonah Chase Bryson Adriel Nathaniel Arthur Juan George Cole Zion Jason Ashton Carlos Calvin Brayden Elliot Rhett Emiliano Ace Jayce Graham Max Braxton Leon Ivan Hayden Jude Malachi Dean Tyler Jesus Zachary Kaiden Elliott Arlo Emmanuel Ayden Bentley Maxwell Amari Ryker Finn Antonio Charlie Maddox Justin Judah Kevin Dawson Matteo Miguel Zayden Camden Messiah Alan Alex Nicolas Felix Alejandro Jesse Beckett Matias Tucker Emilio Xander Knox Oscar Beckham Timothy Abraham Andres Gavin Brody Barrett Hayes Jett Brandon Joel Victor Peter Abel Edward Karter Patrick Richard Grant Avery King Caden Adonis Riley Tristan Kyrie Blake Eric Griffin Malakai Rafael Israel Tate Lukas Nico Marcus Stetson Javier Colt Omar Simon Kash Remington Jeremy Louis Mark Lennox Callum Kairo Nash Kyler Dallas Crew Preston Paxton Steven Zane Kaleb Lane Phoenix Paul Cash Kenneth Bryce Ronan Kaden Maximiliano Walter Maximus Emerson Hendrix Jax Atticus Zayn Tobias Cohen Aziel Kayson Rory Brady Finley Holden Jorge Malcolm Clayton Niko Francisco Josue Brian Bryan Cade Colin Andre Cayden Aidan Muhammad Derek Ali Elian Bodhi Cody Jensen Damien Martin", " ")

' Find the last row with data in column A
lastRow = Cells(Rows.Count, 1).End(xlUp).Row

' Generate a random index within the range of the names list
randomIndex = Int((UBound(namesList) - LBound(namesList) + 1) * Rnd + LBound(namesList))

' Display the randomly selected name in column A
Cells(lastRow + 1, 1).Value = namesList(randomIndex)

End Sub

Filed Under: Articles

Latest Articles

Symantec Internet Security Review

[starreviewmulti id=7 tpl=20] PROS: Norton Internet Security is one of the most trusted brand out there for protecting computers. Real time updates. Protects against all forms of attacks. CONS: As with every Internet Security Suite it can bog down your computer. OVERVIEW: Overall this … [Read More...]

Protect Business From Cyber Attacks

A company is only as safe as its computer network and, though it's hard to admit, many businesses are frightfully unprotected when it comes to possible hackers, viruses, and other nasty internet elements. Cyber attacks have leveled people from all walks of life. A local business owner might have his … [Read More...]

Converting VCR Video to DVD Using Canopus ADVC-55

The specific product we're going to use in this tutorial is effectively a combination of Canopus's high-quality ADVC-55 analogue-to-DV converter and the company's Let's CONVERT software bundle, marketed as an easy-to-use, one-step solution to video capture, conversion and DVD authoring … [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

Artificial Intelligence is Shaping the Solar Energy Field

The global market for solar power is expected to be worth $194.75 billion by 2027. As demand for solar energy solutions rises, solar product … [Read More...]

Navegaki.com.br Removal

Navagaki.com.br is a browser hijacker. The .br in the domain name is for domain names that are registered in Brazil. However, that does not mean it … [Read More...]

How to Remove XP Internet Security 2012

Easiest Removal Option: Remote Repair: Paying an expert to remove this threat is always the easiest option. It's also the most expensive. … [Read More...]

[footer_backtotop]

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