Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a scroll bar to a cell to scroll its contents.
Is that possible? I have many cells with a sepcific height. If the
contents of the cell exceed the height I would want a scrollbar to appear for the cell.... Or does anyone have an alternative solution to this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a scroll bar to a cell to scroll its contents.
Sorry, no can do.
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "SkyKid" wrote in message ... Is that possible? I have many cells with a sepcific height. If the contents of the cell exceed the height I would want a scrollbar to appear for the cell.... Or does anyone have an alternative solution to this? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a scroll bar to a cell to scroll its contents.
This might be a very crude solution but maybe it would give you an idea.
Add a textbox to the worksheet and name it as TextBox1. Then paste this code in the worksheet code module: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub TextBox1.Left = Target.Left TextBox1.Top = Target.Top TextBox1.Width = Target.Width TextBox1.Height = Target.Height TextBox1.MultiLine = True TextBox1.ScrollBars = fmScrollBarsVertical TextBox1.LinkedCell = Target.Address End Sub -- Hope that helps. Vergel Adriano "SkyKid" wrote: Is that possible? I have many cells with a sepcific height. If the contents of the cell exceed the height I would want a scrollbar to appear for the cell.... Or does anyone have an alternative solution to this? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a scroll bar to a cell to scroll its contents.
This might be a very crude solution but maybe it would give you an idea.
Add a textbox to the worksheet and name it as TextBox1. Then paste this code in the worksheet code module: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub TextBox1.Left = Target.Left TextBox1.Top = Target.Top TextBox1.Width = Target.Width TextBox1.Height = Target.Height TextBox1.MultiLine = True TextBox1.ScrollBars = fmScrollBarsVertical TextBox1.LinkedCell = Target.Address End Sub -- Hope that helps. Vergel Adriano "SkyKid" wrote: Is that possible? I have many cells with a sepcific height. If the contents of the cell exceed the height I would want a scrollbar to appear for the cell.... Or does anyone have an alternative solution to this? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a scroll bar to a cell to scroll its contents.
That sounds like a good idea.... I didnt even t hink about using text
boxes...thanks "Vergel Adriano" wrote: This might be a very crude solution but maybe it would give you an idea. Add a textbox to the worksheet and name it as TextBox1. Then paste this code in the worksheet code module: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub TextBox1.Left = Target.Left TextBox1.Top = Target.Top TextBox1.Width = Target.Width TextBox1.Height = Target.Height TextBox1.MultiLine = True TextBox1.ScrollBars = fmScrollBarsVertical TextBox1.LinkedCell = Target.Address End Sub -- Hope that helps. Vergel Adriano "SkyKid" wrote: Is that possible? I have many cells with a sepcific height. If the contents of the cell exceed the height I would want a scrollbar to appear for the cell.... Or does anyone have an alternative solution to this? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a scroll bar to a cell to scroll its contents.
How would that idea work in C#? I'm having some issues trying to find where
the multiline and scrollbars properties for a text box exist in C# "SkyKid" wrote: That sounds like a good idea.... I didnt even t hink about using text boxes...thanks "Vergel Adriano" wrote: This might be a very crude solution but maybe it would give you an idea. Add a textbox to the worksheet and name it as TextBox1. Then paste this code in the worksheet code module: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub TextBox1.Left = Target.Left TextBox1.Top = Target.Top TextBox1.Width = Target.Width TextBox1.Height = Target.Height TextBox1.MultiLine = True TextBox1.ScrollBars = fmScrollBarsVertical TextBox1.LinkedCell = Target.Address End Sub -- Hope that helps. Vergel Adriano "SkyKid" wrote: Is that possible? I have many cells with a sepcific height. If the contents of the cell exceed the height I would want a scrollbar to appear for the cell.... Or does anyone have an alternative solution to this? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a scroll bar to a cell to scroll its contents.
I'm not familiar with C#, but in VB (and VBA), I am able to access the
TextBox directly as an object inside the worksheet. I assume it would be similar in C#. Here's how I would do it in VB. I replaced fmScrollBarsVertical with it's integer value of 2. Dim xlApp As New Excel.Application Dim xlWb As Excel.Workbook xlWb = xlApp.Workbooks.Open("C:\TEMP\Sample.xls") With xlWb.Sheets("Sheet1") .TextBox1.MultiLine = True .TextBox1.ScrollBars = 2 'fmScrollBarsVertical MsgBox(.textbox1.text) End With xlWb.Close(False) xlApp.Quit() -- Hope that helps. Vergel Adriano "SkyKid" wrote: How would that idea work in C#? I'm having some issues trying to find where the multiline and scrollbars properties for a text box exist in C# "SkyKid" wrote: That sounds like a good idea.... I didnt even t hink about using text boxes...thanks "Vergel Adriano" wrote: This might be a very crude solution but maybe it would give you an idea. Add a textbox to the worksheet and name it as TextBox1. Then paste this code in the worksheet code module: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub TextBox1.Left = Target.Left TextBox1.Top = Target.Top TextBox1.Width = Target.Width TextBox1.Height = Target.Height TextBox1.MultiLine = True TextBox1.ScrollBars = fmScrollBarsVertical TextBox1.LinkedCell = Target.Address End Sub -- Hope that helps. Vergel Adriano "SkyKid" wrote: Is that possible? I have many cells with a sepcific height. If the contents of the cell exceed the height I would want a scrollbar to appear for the cell.... Or does anyone have an alternative solution to this? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a scroll bar to a cell to scroll its contents.
by the way, this works with the assumption that the workbook already has a
textbox control named "TextBox1".... -- Hope that helps. Vergel Adriano "Vergel Adriano" wrote: I'm not familiar with C#, but in VB (and VBA), I am able to access the TextBox directly as an object inside the worksheet. I assume it would be similar in C#. Here's how I would do it in VB. I replaced fmScrollBarsVertical with it's integer value of 2. Dim xlApp As New Excel.Application Dim xlWb As Excel.Workbook xlWb = xlApp.Workbooks.Open("C:\TEMP\Sample.xls") With xlWb.Sheets("Sheet1") .TextBox1.MultiLine = True .TextBox1.ScrollBars = 2 'fmScrollBarsVertical MsgBox(.textbox1.text) End With xlWb.Close(False) xlApp.Quit() -- Hope that helps. Vergel Adriano "SkyKid" wrote: How would that idea work in C#? I'm having some issues trying to find where the multiline and scrollbars properties for a text box exist in C# "SkyKid" wrote: That sounds like a good idea.... I didnt even t hink about using text boxes...thanks "Vergel Adriano" wrote: This might be a very crude solution but maybe it would give you an idea. Add a textbox to the worksheet and name it as TextBox1. Then paste this code in the worksheet code module: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub TextBox1.Left = Target.Left TextBox1.Top = Target.Top TextBox1.Width = Target.Width TextBox1.Height = Target.Height TextBox1.MultiLine = True TextBox1.ScrollBars = fmScrollBarsVertical TextBox1.LinkedCell = Target.Address End Sub -- Hope that helps. Vergel Adriano "SkyKid" wrote: Is that possible? I have many cells with a sepcific height. If the contents of the cell exceed the height I would want a scrollbar to appear for the cell.... Or does anyone have an alternative solution to this? |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a scroll bar to a cell to scroll its contents.
Hi,
I have the same problem. I tried to use your code but I don't know how to link it to the cell. Can we link this code to a specific cell? Thanks. "Vergel Adriano" wrote: This might be a very crude solution but maybe it would give you an idea. Add a textbox to the worksheet and name it as TextBox1. Then paste this code in the worksheet code module: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub TextBox1.Left = Target.Left TextBox1.Top = Target.Top TextBox1.Width = Target.Width TextBox1.Height = Target.Height TextBox1.MultiLine = True TextBox1.ScrollBars = fmScrollBarsVertical TextBox1.LinkedCell = Target.Address End Sub -- Hope that helps. Vergel Adriano "SkyKid" wrote: Is that possible? I have many cells with a sepcific height. If the contents of the cell exceed the height I would want a scrollbar to appear for the cell.... Or does anyone have an alternative solution to this? |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a scroll bar to a cell to scroll its contents.
Hi, disregard my previous question. I was such a dummy. :P
"lwidjaya" wrote: Hi, I have the same problem. I tried to use your code but I don't know how to link it to the cell. Can we link this code to a specific cell? Thanks. "Vergel Adriano" wrote: This might be a very crude solution but maybe it would give you an idea. Add a textbox to the worksheet and name it as TextBox1. Then paste this code in the worksheet code module: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count 1 Then Exit Sub TextBox1.Left = Target.Left TextBox1.Top = Target.Top TextBox1.Width = Target.Width TextBox1.Height = Target.Height TextBox1.MultiLine = True TextBox1.ScrollBars = fmScrollBarsVertical TextBox1.LinkedCell = Target.Address End Sub -- Hope that helps. Vergel Adriano "SkyKid" wrote: Is that possible? I have many cells with a sepcific height. If the contents of the cell exceed the height I would want a scrollbar to appear for the cell.... Or does anyone have an alternative solution to this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a scroll bar | Excel Worksheet Functions | |||
How do I put a scroll bar within a cell to change its contents? | Excel Discussion (Misc queries) | |||
adding scroll bar to scroll on cell's content? | Charts and Charting in Excel | |||
Scroll horizontaly with mouse, create same system used to scroll . | New Users to Excel | |||
Cell Contents controlled via a scroll bar | Excel Programming |