In my VBA contacts table I have an email column for all emails. When I click an email from within the table my email program opens and the email address is transferred to the TO: field.
However when I click on the txtEmail box I have in my UserForm nothing happens.
Is it possible to change this so when I click in the txtEmail Box the same will happens like when I click in the Table?
Hello oskar44,
Yes, it can be done. This uses the Windows API which can be a little tricky. You will need to attach a copy of your workbook. I can then add then needed code and post back the workbook with the additions made.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
You might want to look at the FollowHyperlink method.
If posting code please use code tags, see here.
Thanks Leith, please see the attached
Last edited by oskar44; 06-17-2015 at 08:02 AM.
Please Login or Register to view this content.
Thank you Norie, your code worked nicely.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks