Editable Text Based on Drop Down List

[rxharp419]

Hello,

I would like to have a drop-down list in A1.

Based on the value selected in the drop-down list in A1, I would like a specific parage of text to pop up in A2. I would like for this text in A2 to be editable so minor things can be changed as needed.

Is this possible?

 

[My Aswer Is This]

parage???

 

[rxharp419]

parage???

LOL...Paragraph.

 

[My Aswer Is This]

We need exact details.

Like:

If "George" is selected in "A1"

Enter "George is my friend" in "A2"

 

[rxharp419]

We need exact details.

Like:

If "George" is selected in "A1"

Enter "George is my friend" in "A2"

That is a perfect scenario. I just want to be able to edit and change "George is my friend" in A2 if i have to once it is there.

 

[My Aswer Is This]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 1 And Target.Column = 1 Then Target.Offset(1, 0).Value = Target.Value
Target.Offset(1, 0).Select
End Sub

 

[rxharp419]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 1 And Target.Column = 1 Then Target.Offset(1, 0).Value = Target.Value
Target.Offset(1, 0).Select
End Sub

Hi and thank you!

I am not sure what i am doing wrong. But i have more information now that i have been messing around with this.

N1 is the cell i would like to refer to.

Basically, if N1 is "Estimate" than I want H1034 to populate with text i have in another sheet 'Wages & Rates'!J16.

If N1 is Lump Sum than I want H1034 to populate with text i have in another sheet 'Wages & Rates'!J17.

However, I would like the text to be editable as previously explained.

I think that should be all the info i can think of.

 

[My Aswer Is This]

Try this:
This is surely not what you asked for in your first post.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 1 And Target.Column = 14 Then
If Target.Value = "Estimate" Then Range("H1034").Value = Sheets("Wages & Rates").Range("J16").Value
If Target.Value = "Lump Sum" Then Range("H1034").Value = Sheets("Wages & Rates").Range("J17").Value
End If
End Sub

 

[rxharp419]

Try this:
This is surely not what you asked for in your first post.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 1 And Target.Column = 14 Then
If Target.Value = "Estimate" Then Range("H1034").Value = Sheets("Wages & Rates").Range("J16").Value
If Target.Value = "Lump Sum" Then Range("H1034").Value = Sheets("Wages & Rates").Range("J17").Value
End If
End Sub

Hello, Thank you. It still will not work. It won't run, no error codes come up or anything, just a beep noise and it does not run for some reason.

 

[My Aswer Is This]

If you followed my instruction in my previous post. And put the script in the sheet like I said
And then you enter a value into range "N1" the script will run.
And you must enter "Estimate" or "Lump Sum" like you asked for.
You should be able to read the script and see what it does.
It does work for me.
Not sure why you want to enter a value in "N1" and have it up date a value in Range("H1034")
But that is what you asked for.

And the script must be put in the sheet where you plan to enter a value into Range "N1"

In your first post you said "A1" and "A2" so not sure why you are changing things.
Did my first post work?

And your sheet name must be exact. If you know English you should be able to read the script.