Excel VBA Tips n Tricks #20 Random Names Generator

📊 Free Workbooks: www.excelvbais...
🥷Join Excel Ninja Pro: www.excelvbais... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbais... (Free downloads, Trainings, Live Q&A and more)
In this lesson, we show a method of making a macro to generate a random First and Last name using a list of First Names and Last names pulled from various sites on the web.
Check it out!
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbais... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbais...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbais...

[@ProviderKnowledge]

Thanks

[@seynaboudiop3243]

This is a nice video

[@Tedmosby111]

I know this video is 8 years old by now but I HAVE to thank you from the bottom of my heart! I've been stuck at exactly this problem for eternity now and with your approach it worked first try. Thank you so much man!

[@ExcelVbaIsFun]

Thanks for stopping by to say thank you! Means a lot!

[@TechTinkTronics]

Thanks for sharing! There are so many built in functions in Excel and I honestly don't know them all. But I learn everyday.

[@ExcelVbaIsFun]

You're very welcome, TechTinkTronics! So glad to be of help!

[@nextstep2239]

Can you please share this file

[@krn14242]

Dan, after watching this video I created my own random names generator and added a drop down box for user to select either male or female names. And since I had uneven numbers of male versus female, I included some logic to identify the last row for each gender and only provide that many names. Pretty cool. Fun learning VBA and I have to thank you for teaching me. Thanks again.

[@ExcelVbaIsFun]

Wow! That is awesome, Kevin. I'm really glad. When I began, I didn't know if anyone would watch these. It turns out, a lot of people are interested but intimidated. I mean to change that. I'm so glad you're having lots of fun with it. Thanks sir. Dan

[@krn14242]

Interesting choice of first name. Funny. Thanks for the calculate = manual trick. I have been frustrated without that. Debugging is a pain when it was going thru the entire workbook before moving on through my loop. Great tip. Thanks again.

[@ExcelVbaIsFun]

I added one because the column headers (aka row 1) wasn't included. So, instead of telling it to do a random number between row 1 and the count of the list, i did random num between row 2 and count of the list plus one, which would be the number that was the row of the last item of the list. Hope that makes sense. Dan.

[@nicolmoehle1081]

I canot believe that I've finally found a web app that works. Got so many free gems and coins from Gamecrook.

[@ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[@cakehyrbid5315]

Hey dose this still work?

[@ExcelVbaIsFun]

Thanks zombies!

[@rypi5489]

Here’s a challenge for you! If I had titles running down Column A and wanted to Randomly change that title and show the result alongside it in column B how would you do that? So if Range(“A2”) Contained: 64pc Socket Set by Hilka. CRV Metric Sockets 3/8 Drive how could I get this randomly changed into Range(“B2”) ??

[@aprilarchuleta2180]

I've started a similar project but mine involves clicking a button and having a msg box pop up with a random name (only uses first names). Can't quite figure it out. Any way to get assistance?

[@jasminepatna3520]

Gamecrook is working but I don't know how.

[@SheRoMan]

hi .. can you copy what you did in VBA here on comments .. i can't get it right

[@marruz0]

Make sure when you make a video that you do it right without messing up and confusing yourself.