Displaying Cells Comments

[Jmbostock]

I'm trying to display a comment in a cell on a worksheet into a text box
on a userform.

For some reason i just can't get it to work.

Also, i've a very long userform that extends beyond the borders of the
screen and i'd like to put a scroll bar in there to aid in its
navigation. I just can't seem to get the userform to move when i click
on the scroll bar.

Hope someone out there can help me.

Thanks in Advance

James

 

[Bob Phillips]

I'm trying to display a comment in a cell on a worksheet into a text box
on a userform.

For some reason i just can't get it to work.

Try something like

Me.TextBox1.Text = Worksheets(1).Range("A1").Comment.Text

from within the userform