I am trying to accomplish this in Excel using VBA, and keep hitting brick walls:
I would like to create a user form in Excel with checkboxes for 25 different files that exist in a source directory. I would like the user to be able to check off the files that they want to copy, and then move those files to a new temp directory by clicking a command button. After that, I will use another command button to kick off an email, attaching all of the files in that temp directory to the email. The email part is working. The piece that I keep scrapping and starting over is the ability to select those files via checkboxes. Does anyone have any suggestions or samples that may help with what I am trying to do? Thanks in advance for any advice! -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
