using a selection box and moving the accepted data

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

Guest

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
 

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

Back
Top