?
Solved

Clear contents in a cell; conditional of a change in a drop-down list

Posted on 2014-08-18
2
Medium Priority
?
1,154 Views
Last Modified: 2014-08-18
Hi all,
I am looking for a functionality that works in the following way; when I make a change in a drop-down list, then, I would like the content of a given cell to clear. Is this doable? Thanks for your time.
0
Comment
Question by:Utredning
2 Comments
 
LVL 54

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 40267402
HI,

Supposing your dropdown is in A1 and the cell to clear is in B2 pls try in your sheet module

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
    Range("B2").ClearContents
End If
End Sub

Regards
0
 

Author Closing Comment

by:Utredning
ID: 40267411
Super. Thanks.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question