macro that generates random selection set from table

If any of you have the misfortune of being auditors and have to make samples, I made a macro for you. The code is here and the code for the userform below.

any time you have a table of data, you can make a sample from it. It counts the rows in the current region (so the region has to be quarantined off to work). Each row represents a possible selection. You give it your requested number of selections. It spits these out on a new worksheet, highlighted and formatted neatly. If you have a descriptive header on the table (like a row with descriptions, like qty, name, date purchased, etc) as most will, leave that box checked, otherwise uncheck and it will adjust accordingly.

You just need the user form set up. I have never exported those. that's in your hands, hopefully it transfers right. You can get the userform file at https://github.com/webbuildermn/vba-.../VBA%20Modules "SelectionParms.frm and *.frx" and hopefully it goes easily.

Just thought I'd share.

Edit: fixed the range copy/paste when you select a partial custom range.

Please Login or Register  to view this content.

UserForm code

Please Login or Register  to view this content.