MPDenver
asked on
Excel Email Results
This worksheet captures the head to head results on the Legend Votes tab. When it gets to the last vote it displays a message that the voting is complete.
I would like to add the following please.
1 . At the end of the voting have a pop up window to capture the users name and email address.
2 . Email the results to a specific email address defined in the macro and CC the user the results from the
captured email.
Subjuect = Fullname from step 1 with Voting Results. Example "John Doe Voting Results"
3. Clear the results on the spreadsheet to start a new vote.
ExcelVoting.xlsx
I would like to add the following please.
1 . At the end of the voting have a pop up window to capture the users name and email address.
2 . Email the results to a specific email address defined in the macro and CC the user the results from the
captured email.
Subjuect = Fullname from step 1 with Voting Results. Example "John Doe Voting Results"
3. Clear the results on the spreadsheet to start a new vote.
ExcelVoting.xlsx
When does voting 'end'?
ASKER
In the file you can see the code being used. Here is part of the script that calls that out.
I am okay collecting the Name, Email in the Voting Board and just using that vs a pop up.
'finished comparisons
If iBlank = 2 Then
MsgBox ("All comparisons complete")
Exit Sub
End If
I am okay collecting the Name, Email in the Voting Board and just using that vs a pop up.
'finished comparisons
If iBlank = 2 Then
MsgBox ("All comparisons complete")
Exit Sub
End If
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great work thank you !!
My pleasure.