Help with checkbox code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am not sure how to create this. I am using Excel 2003. I have 3 checkboxes
on a user form and I would like that when the user checks which ever box and
clicks the add button it will return to the worksheet a value of YES and
vise-versa if they are not checked it will return a value of NO to the
approiate column,cell.When the add button is clicked.
 
In the userform module-

Private Sub CheckBox1_Change()
ActiveSheet.Range("A1").Value = IIf(Me.CheckBox1.Value, "Yes", "No")
End Sub

Regards,
Peter T
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checkbox or Option Button 2
Validating checkboxes 2
Beginner - Click a checkbox then calculation to be done automatically 1
Show checkbox checked on open 4
Referencing Checkbox Name 1
Simple Checkbox 4
Checkboxes 3
CheckBox values based on Worksheet condition 2

Back
Top