Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print, displaying comments on XL Spreadsheet? | Excel Discussion (Misc queries) | |||
displaying comments | Excel Discussion (Misc queries) | |||
Comments Not displaying Correctly With Panes Frozen? | Excel Discussion (Misc queries) | |||
cells displaying | Excel Discussion (Misc queries) | |||
how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) |