Displaying Cells Comments

  • Thread starter Thread starter Jmbostock
  • Start date Start date
J

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
 
Jmbostock > said:
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.
Click to expand...

Try something like

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

from within the userform
 
Back
Top