| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need Macro to reset dependent list
Hi
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 Then Exit Sub If Target.Column < 1 Then Exit Sub Application.EnableEvents = False Target.Offset(0, 2).ClearContents Application.EnableEvents = True End Sub -- Regards Roger Govier Bean Counter wrote: Hi All, I have a set of 2 lists, one dependent on the other. If the value of the list in column A changes AFTER the value of the list in Column C is selected, I would like for column C to reset, or blank out. I know this can be done because I have seen it done before. It was code that was put into the sheet itself. Can anyone help with this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an Excel macro to reset a drop down list | Excel Discussion (Misc queries) | |||
| Create a list in a drop down dependent upon another dd list in exc | Excel Discussion (Misc queries) | |||
| Return a list dependent upon the selection of a preceeding list | Excel Worksheet Functions | |||
| create 2nd list dependent on 1st list | Excel Worksheet Functions | |||
| How do I create a dependent list, to a current list? | Excel Discussion (Misc queries) | |||
![Roger Govier[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
