Excel VBA Tips n Tricks #20 Random Names Generator

preview_player
Показать описание

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:
Рекомендации по теме
Комментарии
Автор

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!

Tedmosby
Автор

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.

krn
Автор

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

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.

ExcelVbaIsFun
Автор

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”) ??

rypi
Автор

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

TechTinkTronics
Автор

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.

krn
Автор

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?

aprilarchuleta
Автор

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

SheRoMan
Автор

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

ExcelVbaIsFun
Автор

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

marruz
Автор

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

nicolmoehle
Автор

Gamecrook is working but I don't know how.

jasminepatna