Displaying Cells Comments
 

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


---
Message posted from http://www.ExcelForum.com/

Displaying Cells Comments
 

"Jmbostock " wrote in message
...
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