Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
If than copy function / Macro | Excel Worksheet Functions | |||
Using "mailto" function in a macro | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Function Macro for Nested IF | Excel Worksheet Functions |