Excel VBA Tips n Tricks #20 Random Names Generator

No video

Excel VBA Tips n Tricks #20 Random Names Generator

Рет қаралды 17,095

11 жыл бұрын

📊 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...

Пікірлер: 22

@Tedmosby111 2 жыл бұрын

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 2 жыл бұрын

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

@ExcelVbaIsFun 11 жыл бұрын

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 11 жыл бұрын

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.

@ProviderKnowledge Жыл бұрын

Thanks

@TechTinkTronics 4 жыл бұрын

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 4 жыл бұрын

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

@krn14242 11 жыл бұрын

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.

@seynaboudiop3243 3 жыл бұрын

This is a nice video

@ExcelVbaIsFun 11 жыл бұрын

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 11 жыл бұрын

Thanks zombies!

@ExcelVbaIsFun 10 жыл бұрын

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 3 жыл бұрын

Hey dose this still work?

@rypi5489 9 жыл бұрын

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

@SheRoMan 8 жыл бұрын

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

@aprilarchuleta2180 5 жыл бұрын

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?