Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete range on another sheet when checkbox is unchecked
I have an order form. Users check a box next to an item and it copies the
item to another page (the form). I want them to be able to uncheck the box and have it "undo" what the checkmark does. (deletes the item order for that item). Here is the code I'm using to move the item to the order form. Private Sub CheckBox1_Click() If CheckBox1.Value = True Then Worksheets("PartsSheet1").Range("A2:F2").Copy Worksheets("OrderForm").Range("A1") End If End Sub Thank you. Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match and Sort for two range of data on different worksheets? | New Users to Excel | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
How to copy records containing a specific date range to new sheet? | Excel Worksheet Functions | |||
not delete worksheets from names in a range | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions |