Related:
- If checkbox is checked copy and paste excel
- How to check if someone is spying on my whatsapp - Guide
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Number to words in excel - Guide
- Excel marksheet - Guide
1 response
panamabreak
Posts
10
Registration date
Sunday August 31, 2008
Status
Member
Last seen
February 23, 2009
25
Oct 15, 2008 at 10:03 AM
Oct 15, 2008 at 10:03 AM
hey there,
here is a link which will help you a lot:
https://www.techonthenet.com/excel/macros/index.php
here is a link which will help you a lot:
https://www.techonthenet.com/excel/macros/index.php
Oct 15, 2008 at 10:44 AM
I have found a macro that kind of allows me to copy the rows required.... can you help me tweak it so it lets me copy the row in which the checkbox is in and it copies the data into a specified sheet e.g. CheckIn ot CheckOut.
Sub AddSheetandCopy()
Dim sShape As Shape
Dim wsNew As Worksheet
Dim wsStart As Worksheet
Dim Sheet2 As Worksheet
Set wsStart = ActiveSheet
Set wsNew = Sheets.Add()
Set Sheet2 = Worksheet.Select()
For Each sShape In wsStart.Shapes
With sShape
If .FormControlType = xlCheckBox Then
If .ControlFormat.Value = xlOn Then
wsStart.Range("a2:i2").EntireRow.Copy Destination:=Sheet2.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
End If
End If
End With
Next sShape
'wsNew.DrawingObjects.Delete '
End Sub
Apr 22, 2010 at 02:54 AM
were you able to solve this problem?? I' doing something very similar...