Automating the entry of text in Target cell when some value is entered in another cell

[laxminarayana]

Hello,

Is it possible that selecting an item from drop down should enter certain text in a target cell ?

Following image will show, what i am trying achieve

http://s8.postimg.org/70i4m3mut/ster1.png

In cell "N16" there is a drop down with two items 1) pay due 2) Bill

Selecting (pay due) should enter following text

"Payments are due from the dealer, requires special attention." in cell C3

if (Bill) is selected from drop down then it should enter below text

"Require bills to continue with the transaction." should appear in cell C3"

if both (pay due) and (Bill) selected both lines should appear in cell "C3" with one line spacing between them.


Thanks

 

[Jeffrey Lopez]

I would do a Worksheet Change event... maybe something along the lines of:


<code>

Private Sub Worksheet_Change(ByVal Target As Range)

On Error GoTo ErrorHandler:
If Intersect(Target, Range("N16")) Is Nothing Then Exit Sub

Select Case Range("N16").Value
    Case "pay due"
        Range("C3").Value = "Payments are due from the dealer, requires special attention."
    Case "bill"
        Range("C3").Value = "Require bills to continue with the transaction."
    Case "pay due & bill"
        Range("C3").Value = "Payments are due from the dealer, requires special attention." & vbNewLine & vbNewLine & "Require bills to continue with the transaction."
End Select

ErrorHandler:
End Sub

Was not quite sure how you are storing the value for both, so you might need to adjust the value for the third case.

Also since this is a worksheet change event, you will need to put it in the worksheet code...

Hope that helps!




Edit: Sorry sometimes I over think things.. you could also just use a simple "IF" in "C3"...

=IF(N16="pay due","Text here",IF(N16="bill","Text Here",IF(N16="pay due & bill","First Text Here"&CHAR(10)&CHAR(10)&"Second Text Here","")))

</code>