Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Text in Formula Bar for certain cells
I have a column that it only 1 pt wide (and I want to keep it that width) and
I want to display the contents of this cell (which is a formula from another worksheet) in the text format which is not able to be seen because of the width of the cell. If there is a way to make a comment pop up when that cell is highlighted displaying information from another worksheet that would work as well, but I don't think Excel is capable. Thanks Tracy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Text in Formula Bar for certain cells
There are many ways...
Following will show the value in the status bar if you click on any cell in Col F Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Left(Target.Address, 2) = "$F" Then Application.StatusBar = "Cell " & Target.Address & "=" & Target.Value End If End Sub You can also run a macro to add comments to the column... See http://www.contextures.com/xlcomments03.html for excellent examples for dealing with comments... "Tracy" wrote: I have a column that it only 1 pt wide (and I want to keep it that width) and I want to display the contents of this cell (which is a formula from another worksheet) in the text format which is not able to be seen because of the width of the cell. If there is a way to make a comment pop up when that cell is highlighted displaying information from another worksheet that would work as well, but I don't think Excel is capable. Thanks Tracy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Text in Formula Bar for certain cells
Unfortunately you are speaking Greek to me. I do not understand your answer.
Sorry -- Tracy "Tracy" wrote: I have a column that it only 1 pt wide (and I want to keep it that width) and I want to display the contents of this cell (which is a formula from another worksheet) in the text format which is not able to be seen because of the width of the cell. If there is a way to make a comment pop up when that cell is highlighted displaying information from another worksheet that would work as well, but I don't think Excel is capable. Thanks Tracy |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Display Text in Formula Bar for certain cells
Your requirement can be met with a macro. Since you are not familiar with
them you may see and introduction at http://www.taltech.com/support/sw_tricks/exmacros.htm "Tracy" wrote: Unfortunately you are speaking Greek to me. I do not understand your answer. Sorry -- Tracy "Tracy" wrote: I have a column that it only 1 pt wide (and I want to keep it that width) and I want to display the contents of this cell (which is a formula from another worksheet) in the text format which is not able to be seen because of the width of the cell. If there is a way to make a comment pop up when that cell is highlighted displaying information from another worksheet that would work as well, but I don't think Excel is capable. Thanks Tracy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Will Not Display In Cells | Excel Discussion (Misc queries) | |||
Cells within a list to display a certain text but have different v | Excel Discussion (Misc queries) | |||
Display text depending on values of 3 different cells? | Excel Worksheet Functions | |||
Cells formated as text do not always display properly | Excel Discussion (Misc queries) | |||
How do I get merged cells to display all text. | Excel Discussion (Misc queries) |