Populate Cell Based on Drop Down

Microsoft Excel 2000
August 12, 2010 at 12:15:37
Specs: Windows XP
i had a question.
iin A1 cell in excel i can write the value TRUE or FALSE through a drop down list. i want cell B1 respond depending upon the value entered in A1. such as if A1 is true B1 can be written with any value, but if A1 is false B1 will be blank automatically (even if there is any value previously posted).

See More: Populate Cell Based on Drop Down

August 12, 2010 at 12:24:30
A posting suggestion:

When you post in a help forum such as this one, please try to use a Subject Line that gives us an idea of what your question is about.

If everyone used a subject line such as Help Me Out, we wouldn't be able to tell one question from another. In addition, it makes searching the archives for answers a lot harder.

I have edited the subject line for this thread.


Office Forum Moderator

Report •

August 12, 2010 at 12:55:08
You can't use have a formula in B1 that is dependent on A1 (such as an IF statement) and also allow the user to enter "any value".

Once the user enters the value the formula will be overwritten.

To accomplish your goal, you can use a macro that will clear B1 when A1 is changed to FALSE and then prevent user input.

Private Sub Worksheet_Change(ByVal Target As Range)
 If Target.Address = "$A$1" Then
  If Target = False Then
      With Range("B1").Validation
        .Add Type:=xlValidateCustom, _
             AlertStyle:=xlValidAlertStop, _
      End With
  End If
 End If
End Sub

Report •

August 23, 2010 at 10:30:45
thanks. It works


Report •
Related Solutions

Ask Question