Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell to display text from cell on focus??
Hello
Is it possible to have a cell in a worksheet to display all contents of whichever cell has focus? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell to display text from cell on focus??
Paste both of these macros into the sheet module of your sheet. To access
that module, right-click on the sheet tab, select View Code, "X" out of the module to return to your sheet. HTH Otto Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Range("A1").Value = Target.Value Application.EnableEvents = True End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("A1").Value = Target.Value End Sub wrote in message oups.com... Hello Is it possible to have a cell in a worksheet to display all contents of whichever cell has focus? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell to display text from cell on focus??
Super - this is exactly what I was looking for. Thanks !
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display text in one cell as a number in an adjacent cell in excel | New Users to Excel | |||
have one cell display text which reflects a number in another cell | Excel Discussion (Misc queries) | |||
Display contents of cell in another cell as part of text string? | New Users to Excel | |||
display a number in one cell as text in more than one cell? | Excel Discussion (Misc queries) | |||
large text amount in cell will not display in the cell | Excel Discussion (Misc queries) |