Ignore label if option button is not selected

On the attachement,,, tthe userform can have upto 14 questions/sections... not all will be completed at the same time,,, when the Save button is pressed it moves the information onto the Audit Sheet...... the information recorded is;

Audit item from the label..... Colour representing the option button selected.... any comments.....

When the save button is pressed it will also moves the audit item,, even if no option button is selected

What i am trying to do is stop the Audit item from the label being recorded onto the sheet if no option button is selected for that particular item

many thanks

It would be easier if you attached a sample workbook, showing your actual userform structure.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

hi olly

Thanks for the info,,, after posting i have been trying various thing and have discover if i add this line to each question code,, it works..... just noticed,, it wont move the information is option button is selected