Populate Cell Based on Drop Down

Microsoft Excel 2000
August 12, 2010 at 12:15:37
Specs: Windows XP
hi,
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

Report •


#1
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.

Thanks!

DerbyDad03
Office Forum Moderator


Report •

#2
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
    Range("B1").ClearContents
      With Range("B1").Validation
        .Delete
        .Add Type:=xlValidateCustom, _
             AlertStyle:=xlValidAlertStop, _
             Formula1:="=IF(A1=FALSE,,)"
      End With
   Else
      Range("B1").Validation.Delete
  End If
 End If
End Sub


Report •

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

Regards


Report •

Related Solutions


Ask Question