Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show the contet of a cell in another cell
Can anyone tell me, how to do, if I want show the content of a cell in
another cell by clicking on the first cell? Fx. I click on cell A2, and when I do that it is automatically shown in for instance cell D2. Best regards BM. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show the contet of a cell in another cell
Not sure what you want..
If you type =D2 in cell B2 then B2 will always show the value in B2. If you want it to show only when you click on B2 then you need to write a macro... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "Showing the content of a cell in another" wrote: Can anyone tell me, how to do, if I want show the content of a cell in another cell by clicking on the first cell? Fx. I click on cell A2, and when I do that it is automatically shown in for instance cell D2. Best regards BM. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show the contet of a cell in another cell
Hi BM,
Right click on work sheet tab , and write down following code in worksheet selection change event. Range("D2") = ActiveCell.Value Regards Harshawardhan Shastri ================================================== ======== "Showing the content of a cell in another" wrote: Can anyone tell me, how to do, if I want show the content of a cell in another cell by clicking on the first cell? Fx. I click on cell A2, and when I do that it is automatically shown in for instance cell D2. Best regards BM. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Show the contet of a cell in another cell
Hi,
In cell D2 type =CELL("Contents") when you press Enter you will get an error, enter it anyway. Close any warning screens. Click any cell with something in it and press F9. If you don't want to press F9 you can add the following code to your sheet: Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveSheet.Calculate End Sub If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Showing the content of a cell in another" wrote: Can anyone tell me, how to do, if I want show the content of a cell in another cell by clicking on the first cell? Fx. I click on cell A2, and when I do that it is automatically shown in for instance cell D2. Best regards BM. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
type MI in cell, have Michigan show in adjacent cell | Excel Discussion (Misc queries) | |||
How do i assign cell A1 to show the current cursor cell in Excel? | Excel Discussion (Misc queries) | |||
format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
In adjacent cell, show last date modified of target cell. | Excel Discussion (Misc queries) | |||
enter a time into a cell, have the cell show two times the entry | Excel Worksheet Functions |