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!
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.
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
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.
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.
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”) ??
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
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?
Thanks
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!
Thanks for stopping by to say thank you! Means a lot!
This is a nice video
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.
Thanks for sharing! There are so many built in functions in Excel and I honestly don't know them all. But I learn everyday.
You're very welcome, TechTinkTronics! So glad to be of help!
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
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.
Can you please share this file
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.
Thanks zombies!
I canot believe that I've finally found a web app that works. Got so many free gems and coins from Gamecrook.
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”) ??
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
Hey dose this still work?
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?
Gamecrook is working but I don't know how.
Make sure when you make a video that you do it right without messing up and confusing yourself.
hi .. can you copy what you did in VBA here on comments .. i can't get it right