Saving String to Clipboard from Message Box

Hi there

I have created a workbook that will be a useful resource for all leaders in our organisation and it will be available on the National resource page for any member to download - I will have no control over who has this sheet and therefore will have no way of notifying users of updated versions / resolved errors.

I have already added a Comment Box that is fixed open on A1 in all Sheets to advise them of how to contact me if they locate errors or have problems working out how to use the workbook. This box also contains instructions for hiding the comment.

What I want to do is create a Message Box that will pop up upon opening the workbook (this is done in VBA already) which requests they email me if they are interested in receiving updated versions of this workbook. As I know that the majority of our members have Gmail / Hotmail emails, I can't give them an option to select "Email Now" and automatically open a new email message in Outlook that is pre-populated with my email address, but I am wondering if maybe I could programme a button as "Copy Email to Clipboard" and it will then save my email address to the Clipboard for them to paste into a new email.

Please note - the assumption in the creation of this document is that most users will not be very savvy on computers (and/or relatively old), hence the need for this workbook in the first place. I want to make the process as simple as possible for them to use.

Thanks in advance!
justaddculture

I pinched this from down the back of the internet. You can incorporate it into your message box code so it auto copies the email address to the clipboard for the user.

Please Login or Register  to view this content.

BSB