using scroll bar cell

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Using a Scroll bar with a cell of text

Using a Scroll bar with a cell of text

resolvedResolved · Urgent Priority · Version 2003

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


 

Excel tip:

Select Single Data Marker

To select a single data marker in a chart, ie line, bar or column;
After you have pressed Ctrl+Click (to select the entire chart) you can press the Up or Down arrows to select a data series, then press the Left or Right arrow to select a data point within that series.

View all Excel hints and tips


Server loaded in 0.09 secs.