Macro or function
Good afternoon,
I have a situation where the content of a cell is based on what the active cell is. This is to display a Help message. I know i could use the Data Validation Message but this is not a good use for what we are trying to achieve. If the Active cell is A1, then B1 = the content of a cell C1 If the Active cell is A2, then B1 = the content of a cell C2 If the Active cell is A3, then B1 = the content of a cell C3 .... and so on Has anyone created such a macro (i suppose this is a worksheet macro)... Any help woul dbe welcome |
Macro or function
You may try this macro in the SelectionChange event of the worksheet:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error Resume Next If Target.Column = 1 Then Range("B1").Value = Target.Offset(0, 2).Value End If End Sub Hope this helps, Miguel. "MIchel Khennafi" wrote: Good afternoon, I have a situation where the content of a cell is based on what the active cell is. This is to display a Help message. I know i could use the Data Validation Message but this is not a good use for what we are trying to achieve. If the Active cell is A1, then B1 = the content of a cell C1 If the Active cell is A2, then B1 = the content of a cell C2 If the Active cell is A3, then B1 = the content of a cell C3 .... and so on Has anyone created such a macro (i suppose this is a worksheet macro)... Any help woul dbe welcome |
Macro or function
In worksheet code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("A1")) Is Nothing Then Range("B1").Value = Range("C1").Value End If If Not Intersect(Target, Range("A2")) Is Nothing Then Range("B1").Value = Range("C2").Value End If If Not Intersect(Target, Range("A3")) Is Nothing Then Range("B1").Value = Range("C3").Value End If End Sub This will trigger from either a mouse click or arrow key usage. REMEMBER: worksheet code -- Gary's Student "MIchel Khennafi" wrote: Good afternoon, I have a situation where the content of a cell is based on what the active cell is. This is to display a Help message. I know i could use the Data Validation Message but this is not a good use for what we are trying to achieve. If the Active cell is A1, then B1 = the content of a cell C1 If the Active cell is A2, then B1 = the content of a cell C2 If the Active cell is A3, then B1 = the content of a cell C3 .... and so on Has anyone created such a macro (i suppose this is a worksheet macro)... Any help woul dbe welcome |
All times are GMT +1. The time now is 06:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com