Return Yes/No to Cell Based On Option Button

  • i have a user form in my spreadsheet that uses option buttons and text boxes for user entry. i need to take the values and true false entries from the option buttons and place them in cells. i am alittle lost with this. please help - ! thanks for your time

  • Re: Insert Data From Form Into Spreadsheet


    Quote

    i need to take the values and true false entries from the option buttons and place them in cells.


    Could you be a little more specific? Which cells?


    Is this a userform that you created?

  • Re: Insert Data From Form Into Spreadsheet


    Is this what you need?


  • Re: Insert Data From Form Into Spreadsheet


    "i have a user form in my spreadsheet that uses option buttons and text boxes for user entry. i need to take the values and true false entries from the option buttons and place them in cells."



    This should get you started.

  • Re: Insert Data From Form Into Spreadsheet


    Or,

    Code
    Private Sub CommandButton1_Click()
        Sheet1.Range("A1") = Choose(Me.OptionButton1 + 2, "Yes", "No")
    End Sub

    Where Sheet1 is a CodeName.

Participate now!

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