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?
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
