Active Cell displayed in another cell?

[Guest]

I have a column where the cell contents are sometimes 200+ characters long.
For me to see everything, I have to widen the column almost full-width of my
screen, forcing all other columns off the screen, leaving me no choice but to
scroll back and forth.

Normally, I could just select that cell and look in the Formula Bar to see
that cell's full contents. Unfortunately, this column uses a VLOOKUP formula
to populate the cells so I cannot see what the values are; all I see are the
formulas.

My worksheet already has split panes. In the top pane, I would like to merge
several cells together and be able to see the full width of any cell I select
*without* resizing that cell in the bottom pane. Can this be done?

 

[Earl Kiosterud]

Rich,

An event-driven macro could put the selected cell where you want it. Or
maybe better yet, in the status bar, or in a modeless form (stays on the
screen, and lets you continue working. Requires Excel 2000 or newer). We
can write it for you if you're interested.

 

[R.VENKATARAMAN]

see this url
http://groups.google.com/group/microsoft.public.excel.misc/browse_frm/thread
/8b9e14819e518a7a/2d2903c450a5094c?lnk=st&q=see+cell+value+not+formula+in+fo
rmula+bar&rnum=1#2d2903c450a5094c

copy all the lines and paste in the address bar of your browser

I think (I am not an expert) it is not possible to show in the formula bar
only the value and not the formula

but you can try this
create a command button onthe sheet
the code will be

Private Sub CommandButton1_Click()
MsgBox ActiveCell.Value
End Sub

then highlight any cell and click command button

you will get the message box with the value of the active cell

try and see whether it satisfies your purpose.

 

[rgarber50]

Have you thought obout using the format/alignment/wrap text feature?
This way you could adjust the row height and the column width could
remain the same. Perhaps you could create a macro that toggles row
autofit on and off?

I hope I understand what you are trying to achieve and this helps
Richard