using a selection box and moving the accepted data

On a bid sheet I want to put in a check box and when it is checked, have the
data move to another column automatically.

in design mode if you right click and click view code and under
checkboxclick wirte your code in your case
range(....).copy destination:=range(...)

e.g.

Private Sub CheckBox1_Click()
Range("c4:c15").Copy Destination:=Range("d1")
End Sub



"madsenfence" <madsenfence@discussions.microsoft.com> wrote in message
news:98A24D10-8225-4245-9B37-BB454F135889@microsoft.com...
> On a bid sheet I want to put in a check box and when it is checked, have
> the
> data move to another column automatically.