Running Macro Based on Cell

[box-o-rocks]

Hello, I am trying to have a macro run such that when a list in cell F11 = "2P", cells C11&C12 merge.

I have done some research on this, and understand I cannot simply use and If statement in cell C11, but using VBA has not seem to work to recognize the cells value.

My coding skills are not terrible, but I am not exactly well educated on VBA coding.

If there is a better way than using a macro, I would like to hear it.

Thanks for any help.

[LeoTaxi]

Code not in Module, code in WorkSheet Change Event

Please Login or Register  to view this content.

Kind regards
Leo

[box-o-rocks]

Thank you for the help. I have tweaked the code to test it for my needs.

Is there a way to set the range for F11:52 so that it can recognize each row, and change only the associated rows? The below code is an example of how the value of F11 effects C11:13 & D11:13.

If Target.Address = "$F$11" Then
If Target.Value = "2P" Then Range("C11", "C12").Merge
If Target.Value = "2P" Then Range("D11", "D12").Merge
If Target.Value = "2P" Then Range("C12").Borders(xlInsideHorizontal).LineStyle = xlContinuous
If Target.Value = "3P" Then Range("C11", "C13").Merge
If Target.Value = "2P" Then Range("D11", "D13").Merge
If Target.Value = "1P" Then Range("C11", "C13").UnMerge
If Target.Value = "1P" Then Range("C11", "C13").Borders(xlInsideHorizontal).LineStyle = xlContinuous
If Target.Value = "1P" Then Range("D11", "D13").UnMerge
If Target.Value = "1P" Then Range("D11", "D13").Borders(xlInsideHorizontal).LineStyle = xlContinuous
End If

[LeoTaxi]

Maybe

Please Login or Register  to view this content.

Kind regards
Leo

[box-o-rocks]

Select Case... I always forget about that method. I had to tweak the code a little, but that worked out well. Thank you!