Yes / No Choice Only In Cell

  • I have a spreadsheet with several rows of data. Would I would like is a pair of buttons on each row where the user could approve/not approve the info on that particular row.
    I've tried Option buttons from the Forms toolbar, but you can only choose one option on the entire page, not one per line.

    Anyone have any thoughts?

  • Re: Option Boxes Yes/no Application

    Yes - use a dropdown list of Yes/No created with Data>Validation...

    1 advantage - no need to have multiple controls on the worksheet, which would just bloat the workbook.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!