Scrolling within a comments box

[Solihull]

Hi folks - Does anyone know how to get scroll bars operating within a comments box?

[Palmetto]

Excel does not support scroll bars in a comment box.
You could, though, create a userform to display the comments in a textbox which can have a scroll bar.

See attached. Select cell A1 on sheet1.

[Solihull]

Thanks for this it's excellent - question is how do I achieve it?

[Palmetto]

Thanks for this it's excellent - question is how do I achieve it?

Take some time to explore the workbook, particularly the VBA.
To access the VB Editor, press Alt + F11 keys. When finished with the VBE, press Alt + Q to exit.

In the workbook is a very basic userform with a single textbox that uses this simple code to get the comments from the activecell:

Please Login or Register  to view this content.

The user form is currently on set to show only when you select cell A1, but can be amended to encompass a larger range of cells. The worksheet module uses this bit of code:

Please Login or Register  to view this content.

The code is not fully developed or very robust and was only intended to show you a workaround since comment boxes don't support scrollbars.

[Solihull]

First rate, thank you very much.