Basic Checkbox question

[Guest]

I am trying to make an excel program such that clicking a check box will
bring in 5 year budget data from another worksheet into five separate cells,
and the data will flow into =SUM equations. Also important is that when I
uncheck the box, the data disappears. I will need to make about 40 of these
check boxes, each of which refers to a different line of data. The options
the user will check off are not mutually exclusive, so I need any number of
them to appear or disappear simultaneously.

I would appreciate any guidance on what I imagine is not a difficult
problem, but too difficult for me.
Thanks!

 

[Crowbar via OfficeKB.com]

Try this

Place both a Checkbox and Textbox on a userform

And test this code

Private Sub CheckBox1_Click()

If CheckBox1.Value = True Then
TextBox1.Text = "$1500"
Else
TextBox1.Text = ""
End If

End Sub

'If you want to capture data from a cell on the worksheet do this do this

'TextBox1.Text = Sheet1.Cells(1, 1).Text

You should be able to extend this to accomplish your sheet

You can contact me at (e-mail address removed) if you require further instruction