Forum home » Delegate support and help forum » Microsoft Excel Training and help » Using a Scroll bar with a cell of text
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Using a Scroll bar with a cell of text
Resolved · Urgent Priority · Version 2003
Reply Tue 9 Sep 2008, 17:43Delegate Mette said...
Mette has attended:
Excel Advanced course
Using a Scroll bar with a cell of text
Hi
Is it possible to creat a form that we can add a scroll bar function to be able to view all the text within a cell area of the form?
Just like this question box I am typing in right now? Do I need to be in a different programme like word?
For upcoming training course dates see: Pricing & availability
RE: using a Scroll bar with a cell of text
Hi Mette
Thank you for your question
It is not possible to add scroll bars to a cell.
If you are working in Excel and wish to enter data in this manner, then it is possible to create a form with text boxes that have scroll bars. The user would type into the form and the cells in the spreadsheet would be automatically updated.
To do this however you would have to gain a good working knowledge of VBA; for instance by attending the Excel VBA course
Regards
Stephen
|