Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Contents controlled via a scroll bar
Cell contains multiple lines of notes. However do not want to increase the
size of the cell. Is there a way to add a vertical scroll bar and link it to the cell to show the contents of the cell? If so, could some one tell me how to go about doing that? Thanks in advance ak |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Contents controlled via a scroll bar
Nothing in terms of a scroll bar. But how about something like this. When the
user double clicks on the cell a message box pops up showing the full contents of the cell... That might just do the trick... Here is some code Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True MsgBox Target.Value End Sub Right click on the sheet tab that you want to utilize this function. Choose View Code and paste this into the code window... HTH "AK" wrote: Cell contains multiple lines of notes. However do not want to increase the size of the cell. Is there a way to add a vertical scroll bar and link it to the cell to show the contents of the cell? If so, could some one tell me how to go about doing that? Thanks in advance ak |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate contents of cells whose contents resemble cell referem | Excel Worksheet Functions | |||
How do I put a scroll bar within a cell to change its contents? | Excel Discussion (Misc queries) | |||
Data Validation List content controlled from cell | Excel Worksheet Functions | |||
Can xy graph origin be controlled from a cell? | Excel Discussion (Misc queries) | |||
Cell value controlled by button | Excel Programming |