ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   using a selection box and moving the accepted data (https://www.excelbanter.com/excel-worksheet-functions/65975-using-selection-box-moving-accepted-data.html)

madsenfence

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.

R..VENKATARAMAN

using a selection box and moving the accepted data
 
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" wrote in message
...
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.





All times are GMT +1. The time now is 05:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com