Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying contents of Active Cell
Hello, in my spreadsheet I would like to display the contents of an active
cell in a different cell. As in, I select cell AB5 ("apples") and "apples" would be displayed in cell A1; if E25 ("fox") is selected, the result in A1 would be "fox". I appreciate any suggestions. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying contents of Active Cell
You will need to use a macro. Set the Security level to low/medium in
(Tools|Macro|Security). Right click the sheet tab View Code and paste the below code. Try selecting in that sheet.. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("A1") = Target.Value End Sub If this post helps click Yes --------------- Jacob Skaria "Rope" wrote: Hello, in my spreadsheet I would like to display the contents of an active cell in a different cell. As in, I select cell AB5 ("apples") and "apples" would be displayed in cell A1; if E25 ("fox") is selected, the result in A1 would be "fox". I appreciate any suggestions. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying contents of Active Cell
Jacob, That works great. Thank you very much for the assistance. Rope...
"Jacob Skaria" wrote: You will need to use a macro. Set the Security level to low/medium in (Tools|Macro|Security). Right click the sheet tab View Code and paste the below code. Try selecting in that sheet.. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("A1") = Target.Value End Sub If this post helps click Yes --------------- Jacob Skaria "Rope" wrote: Hello, in my spreadsheet I would like to display the contents of an active cell in a different cell. As in, I select cell AB5 ("apples") and "apples" would be displayed in cell A1; if E25 ("fox") is selected, the result in A1 would be "fox". I appreciate any suggestions. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying contents of Active Cell
Jacab, This worked great. Thanks very much for the assist. Rope.
"Rope" wrote: Hello, in my spreadsheet I would like to display the contents of an active cell in a different cell. As in, I select cell AB5 ("apples") and "apples" would be displayed in cell A1; if E25 ("fox") is selected, the result in A1 would be "fox". I appreciate any suggestions. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying contents of Active Cell
Cheers.
If this post helps click Yes --------------- Jacob Skaria "Rope" wrote: Jacob, That works great. Thank you very much for the assistance. Rope... "Jacob Skaria" wrote: You will need to use a macro. Set the Security level to low/medium in (Tools|Macro|Security). Right click the sheet tab View Code and paste the below code. Try selecting in that sheet.. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("A1") = Target.Value End Sub If this post helps click Yes --------------- Jacob Skaria "Rope" wrote: Hello, in my spreadsheet I would like to display the contents of an active cell in a different cell. As in, I select cell AB5 ("apples") and "apples" would be displayed in cell A1; if E25 ("fox") is selected, the result in A1 would be "fox". I appreciate any suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying Cell Contents | Excel Discussion (Misc queries) | |||
Help with displaying the contents of the last populate cell. | New Users to Excel | |||
Shortcut key for displaying the active cell comment | Excel Discussion (Misc queries) | |||
Displaying cell contents on one sheet | Excel Discussion (Misc queries) | |||
Displaying contents of cell on different spreadsheet | Excel Discussion (Misc queries) |