Show cell comments in userform text box.

[Yappa]

Hi all,

I have a userform which scrolls up and down rows, displaying the the relevant cell information in it's text boxes.

What I am trying to do now is show the comments text in a userform text box.

I've tried this code with no success:

Please Login or Register  to view this content.

Can anyone help?

Thanks,

Yappa

[Trebor76]

Hi Yappa,

Though it should actually be ".Comment" not ".Comments", the code still errored out after I changed it. I therefore assigned the cell comment a string variable and referenced the text box to that variable (see below) and all was fine.

HTH

Robert

Please Login or Register  to view this content.

[Yappa]

Thanks Robert works perfect.

Did have comment originally, I was trying all sorts of stuff but what you've showed me I didn't think of. Thanks again.

Yappa

[Trebor76]

You're welcome - always (especially) happy to help a fellow Aussie