Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
making one cell show contents of other selected cells...automatica
(Excel 2003)
I need for one particular cell to equal the contents of the cell the curser has selected. For example the cell to show the result (A1) would automatically show the contents of whichever cell is selected by the user when they click on a particular cell. Sounds odd I know, but there is method to my madness.. Can anyone help? Thanks, Roger |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
making one cell show contents of other selected cells...automatica
Hi
This event code is to be inserted into the code sheet for the desired sheet: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address < "$A$1" Then Application.EnableEvents = False Range("A1") = Target.Value Application.EnableEvents = True End If End Sub Regards, Per "Roger on Excel" skrev i meddelelsen ... (Excel 2003) I need for one particular cell to equal the contents of the cell the curser has selected. For example the cell to show the result (A1) would automatically show the contents of whichever cell is selected by the user when they click on a particular cell. Sounds odd I know, but there is method to my madness.. Can anyone help? Thanks, Roger |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
making one cell show contents of other selected cells...automa
Dear Per,
Thankyou for this - works perfectly. Best regards, Roger "Per Jessen" wrote: Hi This event code is to be inserted into the code sheet for the desired sheet: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address < "$A$1" Then Application.EnableEvents = False Range("A1") = Target.Value Application.EnableEvents = True End If End Sub Regards, Per "Roger on Excel" skrev i meddelelsen ... (Excel 2003) I need for one particular cell to equal the contents of the cell the curser has selected. For example the cell to show the result (A1) would automatically show the contents of whichever cell is selected by the user when they click on a particular cell. Sounds odd I know, but there is method to my madness.. Can anyone help? Thanks, Roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make an Excel file selected in Explorer open automatica. | Excel Discussion (Misc queries) | |||
Making selected cells more visible | Excel Discussion (Misc queries) | |||
making # + or - based on another cells contents | Excel Discussion (Misc queries) | |||
Making cells show nothing | Excel Worksheet Functions | |||
Making A Nacro To Change The Contents Of Many Cells | Excel Programming |