Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Contents
I have a very large spreadsheet. In Column D is the Action/Subject for the
row. As I scroll across I would like to add contents of of that cell to either one or two places. First, either to the top where it says "Microsoft Excel - GB Taskings" or to the bottom left where it says "Ready" just below the sheet names. As an example say for the top it counld read "Microsoft Excel - GB Taskings (POTUS Visit). POTUS Visit being the contents on the column D for the active row. If there is a better method please advise. I really do not wabt to freeze the window. Thanks Bill |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Contents
Right click on the sheet tab and select view code. Put in code like this.
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.StatusBar = Cells(Target(1).Row, 4).Value End Sub To reset the status bar, execute code that does Application.StatusBar = False Regards, Tom Ogilvy "Bill" wrote in message ... I have a very large spreadsheet. In Column D is the Action/Subject for the row. As I scroll across I would like to add contents of of that cell to either one or two places. First, either to the top where it says "Microsoft Excel - GB Taskings" or to the bottom left where it says "Ready" just below the sheet names. As an example say for the top it counld read "Microsoft Excel - GB Taskings (POTUS Visit). POTUS Visit being the contents on the column D for the active row. If there is a better method please advise. I really do not wabt to freeze the window. Thanks Bill |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate contents of cells whose contents resemble cell referem | Excel Worksheet Functions | |||
nested Cell("contents", w/ cell contents reference) | Excel Worksheet Functions | |||
Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
Copying cell contents to add to existing contents in another cell | Excel Programming |