Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Contents Help
I'd like some help with clearing contents using vba.
If cell D18="Combo" (selected from a Data Validation List), clear the contents of cells D19, D20, D21, D22 & D26. If cell D18="One" (selected from a Data Validation List), clear the contents of cells D23, D24, D26, D27, D28 & D29. Much thanks in advance! -Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Contents Help
You can use the change event to do this
Place the code in the Sheet module Right click on a sheet tab and choose view code Paste the code there Alt-Q to go back to Excel Private Sub Worksheet_Change(ByVal Target As Range) If Not Application.Intersect(Range("D18"), Target) Is Nothing Then If Target.Value = "Combo" Then Range("D19, D20, D21, D22:D26").ClearContents If Target.Value = "One" Then Range("D23, D24, D26, D27, D28:D29").ClearContents End If End Sub -- Regards Ron De Bruin http://www.rondebruin.nl "michael" wrote in message oups.com... I'd like some help with clearing contents using vba. If cell D18="Combo" (selected from a Data Validation List), clear the contents of cells D19, D20, D21, D22 & D26. If cell D18="One" (selected from a Data Validation List), clear the contents of cells D23, D24, D26, D27, D28 & D29. Much thanks in advance! -Mike |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Contents Help
Sub ClearData
If Range("D18").Value = "Combo" then Range("D19:D22").ClearContents Range("D26").ClearContents elseif Range("D18").value = "One" then Range("D23:D24").ClearContents Range("D26:D29").ClearContents end if End Sub HTH Die_Another_Day michael wrote: I'd like some help with clearing contents using vba. If cell D18="Combo" (selected from a Data Validation List), clear the contents of cells D19, D20, D21, D22 & D26. If cell D18="One" (selected from a Data Validation List), clear the contents of cells D23, D24, D26, D27, D28 & D29. Much thanks in advance! -Mike |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clear Contents Help
Thank you!
michael wrote: I'd like some help with clearing contents using vba. If cell D18="Combo" (selected from a Data Validation List), clear the contents of cells D19, D20, D21, D22 & D26. If cell D18="One" (selected from a Data Validation List), clear the contents of cells D23, D24, D26, D27, D28 & D29. Much thanks in advance! -Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clear Contents | Setting up and Configuration of Excel | |||
Clear Contents | Excel Discussion (Misc queries) | |||
vb to clear cell contents | New Users to Excel | |||
Clear contents if x is not in the row | Excel Programming | |||
Fastest way to clear contents | Excel Programming |