Macro to Clear Cell if entry made in different cell

I have been using Excel for years, but am very new to using Macros. I am developing a spreadsheet to help our salespeople with quoting products. There are options that are available, but if certain options are selected, others are not available or are included automatically.

I would like to set the sheet up so if this scenario comes up, the price will not include the unavailable or included option.

Options A & B are marked in Cells A:20 and A:21. If option C or D (A:38 or A:39) is selected by the customer, Option A or B is already included in the price.

I need to have things so that if any number is entered in Cell A:38 or A:39, the contents of A:20 AND A:21 are cleared. The preferred setup would have this occur automatically when data is entered into A:38 or39. Thanks in advance for your help.

rrtechno,

Sounds like you want a Worksheet_Change event. See attached for how to implement it, and use the following code:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar