Forum Discussion
Drop-down lists
That would require VBA.
Right-click the sheet tab.
Select 'View Code' from the context menu.
Copy the code listed below into the code window.
Switch back to Excel.
Save the workbook as a macro-enabled workbook (*.xlsm).
Make sure that you allow macros when you open it.
Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Range("C3"), Target) Is Nothing Then Application.EnableEvents = False Range("C9:C9,C23:C24").ClearContents Application.EnableEvents = True End If End Sub
If you would like more help, please attach a sample workbook without sensitive data, and include a detailed description of what you want.
HansVogelaar - Thank you for your help. On the attached Worksheet, Claims is only one of many subcategories in the drop down list. I'd like for the blue titles on the worksheet to stay, but the text that I entered to be cleared when I click on another subcaterogy, so that I can enter the correct text for that subcategory. I want only the titles and that text to be visible when someone clicks on that subcategory.
That would require VBA.
Right-click the sheet tab.
Select 'View Code' from the context menu.
Copy the code listed below into the code window.
Switch back to Excel.
Save the workbook as a macro-enabled workbook (*.xlsm).
Make sure that you allow macros when you open it.
Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Range("C3"), Target) Is Nothing Then Application.EnableEvents = False Range("C9:C9,C23:C24").ClearContents Application.EnableEvents = True End If End Sub- Thank you, again, Hans. Much appreciated.
