Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell selection
Is there a way for me to select a cell and then have the information in
another cell change values? i.e. I select cell E1 by clicking on the cell with my mouse. I would like the information in cell A15 to change to a stored value in another cell, G5. Is this possible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell selection
You could use this code in the Worksheet_SelectionChange event.
If Target.Address = ("$E$1") Then Range("A15").Value = Range("G5").Value You can access this by right clicking on the worksheet in question and choosing view code. Change the drop down box showing General to Worksheet and the SelectionChange event should automatically appear. Cheers, Matt "ronreggin" wrote: Is there a way for me to select a cell and then have the information in another cell change values? i.e. I select cell E1 by clicking on the cell with my mouse. I would like the information in cell A15 to change to a stored value in another cell, G5. Is this possible? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell selection
One way is with a worksheet selection change event.
Put the code in the worksheet module Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$E$1" Then Range("A15") = Range("G5") End If End Sub -- steveB Remove "AYN" from email to respond "ronreggin" wrote in message ... Is there a way for me to select a cell and then have the information in another cell change values? i.e. I select cell E1 by clicking on the cell with my mouse. I would like the information in cell A15 to change to a stored value in another cell, G5. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
Force entry into cell, based on validation selection in adjacent cell | Excel Worksheet Functions | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |