ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   scrolling text (https://www.excelbanter.com/excel-programming/344126-scrolling-text.html)

ColsHub

scrolling text
 
I have a very tall cell in my spreadsheet. Does anyone know how to use
view/toolbars/control_toolbox/Scrollbar to scroll the text within a
cell? It would be nice if the scrollbar would automatically appear if
your text exceeded the height of the cell



K Dales[_2_]

scrolling text
 
Cells don't support scrolling, and while it may be possible to work out a
scrolling routine for them I sure wouldn't want to code it.
Would it be possible to simply embed a scrolling textbox within the cell to
achieve your purpose?
--
- K Dales


"ColsHub" wrote:

I have a very tall cell in my spreadsheet. Does anyone know how to use
view/toolbars/control_toolbox/Scrollbar to scroll the text within a
cell? It would be nice if the scrollbar would automatically appear if
your text exceeded the height of the cell




Tom Ogilvy

scrolling text
 
I doubt it would be possible (although you might be able to simulate
something by dealing with substrings)

Why not put a textbox over the cell and link it to the cell if you need to
have the text in the cell as well. An activeX textbox should have its own
built in scrollbar.

--
Regards,
Tom Ogilvy

"ColsHub" wrote in message
oups.com...
I have a very tall cell in my spreadsheet. Does anyone know how to use
view/toolbars/control_toolbox/Scrollbar to scroll the text within a
cell? It would be nice if the scrollbar would automatically appear if
your text exceeded the height of the cell






All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com