Trying to have radio button replace a variable in mail sender code then send

Hello All,

So here is what I am trying to do. I am trying to have different radio buttons send an email to myself with the given code (seen below). I am trying to write a code that will replace the variable "A" with the corresponding option button number. (i.e. if its for optionbutton51, replace A with 51 and then begin the checkmail coding). I've been able to successfully press the radio button and have the mail sent, though it is not replacing the variable A with corresponding button number.

Just a heads up, I am self teaching myself VBA by reading books in my spare time so I can assist my company run things a little better. If this is a simple fix, apologies for overlooking the simple coding. Below is the code I currently have. I tried previously to use the replace function as well, though it did not work. I also tied to include the option button in the createmail sub and wound up getting 422 emails due to not having a stop.


-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

You can do most of the work in a worksheet to simplify the code. I suggest that instead of trying to detect the radio button itself in the code, link all your radio buttons (how many are there?) to a cell, then you can query the value of that cell in your code without having to worry about the buttons in code.

Also note that your message and you subject are both referring to the same cell. Looks like that might be an error.

See attached example. For this to work, it uses Form buttons instead of ActiveX. I usually prefer ActiveX, but the advantage of the form buttons here is that you can have a single cell that shows the index of the button that is pressed.