VBA Code for Option Buttons to return YES or NO instead of TRUE or FALSE

Hello ladies and gentlemen,

I need some help; I have an Excel spread sheet that I use for data collection for my job. I commission solar inverters. Each row contains information for the station that I am commissioning. I collect this data with a UserForm that I created and this with a button on the UserForm it will fill out the PDF Commissioning Report with the data from that row. Right now I am using list boxes for yes and no because Adobe Acrobat requires “Yes” or “No” for Checkboxes not “True” or “False”. I would like to be able to use OptionButtons.

Example: There are 3 Station Types, so I would like to have 3 OptionButtons in a group StationType. The options would be named “zAC”, “zAD” and “zAE” (they have to be named that way due to other code in my form) and they would return values “Yes” or “No” to their respective cells AC, AD and AE for the row that I am currently entering data on.

I’ve searched the internet and tried multiple codes but I can’t get any of them to work, either it still returns “True” or “False” to the cells or I get an error. It’s probably me; I’m not the best with Visual Basics. Any help with a code that would work would be much appreciated.