It sounds like you have the code you need. Just tie the code to the Click
event of the button on the userform.

--
Regards,
Tom Ogilvy

"dok112 " wrote in message
...
Ok,

So I have part of my macro, and I need for it to create a new email
being sent to me when the tab is clicked. I don't want it to send it
to me automatically. It's going to be a Comment/Suggestion email that
I need to implement on my userform. I've tried everything I can find
here and several other websites, but it all pertains to sending
workbooks/sheets automatically. Not the way I need it.


---
Message posted from http://www.ExcelForum.com/