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

[mebanet]

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.

[ragulduy]

Can you just use something like:

Please Login or Register  to view this content.

[mebanet]

Up Load.zip

It's still not working. I'm uploading my file. In the folder there are two Excel files, one with Toggle Buttons and one with Option Buttons. I put the Toggle Buttons on one because I think the code for them will be easier but I would prefer Option Buttons; however I can’t get either to work so I’ll take what I can get.
Option Buttons:
1. There are 3 Option Buttons named zI, zJ and zK captioned “SMA CoMVPP” “SMA MVPP” and “CUSTOMER SUPPLIED” respectively.
2. Option Button zI will enter data in to Cell I for the current row I am entering data in, zJ will enter into J and zK will enter into K.
3. Right now if I check zI, “True” will be entered into Cell I and “False” will be entered into Cells J and K.
4. If you look at my UserForm you will notice that there is a Command Button labeled “Generate Report” if you click it, it will transfer the data from the selected row in the Excel spread sheet to a PDF which I have also included in the upload.
5. Unfortunately Adobe Acrobat requires “Yes” and “No” for checkboxes not “True” and “False” so everything will be filled out accept the checkboxes on the PDF.
6. So I need the Option Buttons to return “Yes” and “No” to their respective cells instead of “True” and “False”
Toggle Buttons:
1. The Toggle Buttons will do the same as the Option Buttons except I can click all of them at the same time.
Yudlugar’s code probally works, I’m probably just not entering it right.

[jaslake]

Hi mebanet

Welcome to the Forum!

Try this Code for your Save Button

Please Login or Register  to view this content.

[mebanet]

Yes, that code worked thank you. The only problem is that the "Get Data" sub wasn't working correctly. When I open the UserForm on a row that has data it is populated with that data. All my Text Boxes were working fine but my Toggle Buttons were grayed out. They were looking for a True or False to tell them what state they should be in. I had to add a bit of code to the "Get Data" sub to fix this problem.

New "Get Data" Code

Please Login or Register  to view this content.

Old "Get Data" Code

Please Login or Register  to view this content.