eagerbeav3r
New Member
- Joined
- Feb 24, 2022
- Messages
- 14
- Office Version
- 365
- Platform
- Windows
Hello everyone,
i got one Main Sheet in which im planning to use Checkboxes to Copy certain Cells from one Sheet into another.
The Contents I want to Copy are in Sheet "NÖ1" and should appear in "NÖ2". When you use it you should decide which "module" should appear in "NÖ2".
This is my Code for now:
I got a button which saves the Sheet "NÖ2" as an PDF file in a specific folder.
My question now is if there is a way to specificly copy the Range in Sheet "NÖ1" in the next clear cell in "NÖ2"? It shouldnt overwrite any other modules and when "Checkbox1 = False" it should only delete the previously pasted module.
Is there a way to do that?
i got one Main Sheet in which im planning to use Checkboxes to Copy certain Cells from one Sheet into another.
The Contents I want to Copy are in Sheet "NÖ1" and should appear in "NÖ2". When you use it you should decide which "module" should appear in "NÖ2".
This is my Code for now:
VBA Code:
Private Sub CheckBox1_Click()
If ActiveSheet.CheckBox1 = True Then
Sheets("NÖ1").Range("B2:I23").Copy Destination:=Sheets("NÖ2").Range("A1:H22")
Exit Sub
End If
If ActiveSheet.CheckBox1 = False Then
Sheets("NÖ2").Range("A1:H22").ClearContents
Sheets("NÖ2").Range("A1:H22").ClearFormats
Exit Sub
End If
End Sub
I got a button which saves the Sheet "NÖ2" as an PDF file in a specific folder.
My question now is if there is a way to specificly copy the Range in Sheet "NÖ1" in the next clear cell in "NÖ2"? It shouldnt overwrite any other modules and when "Checkbox1 = False" it should only delete the previously pasted module.
Is there a way to do that?