Adding Cell Comments from TextBox entry

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

excelnut1954 - 23 Jan 2006 21:53 GMT

Here is one I can't find any info on. In a UserForm, the user has the
option of entering text in TextBox7 to be entered as Cell Comments.
Let's say that this text would be entered to the named range
"CellComment".

Anybody know how this would be done?

Thanks,
J.O.

Reply to this Message

JakeyC - 23 Jan 2006 21:58 GMT

If your textbox is named "TextBox1" and is on "UserForm1", and you wish
the contents to be used as a comment in cell B5 then use the code:

Range("B5").AddComment (TextBox1.Value)

Reply to this Message

Tom Ogilvy - 23 Jan 2006 22:01 GMT

Range("Cellcomment").NoteText Text:=Textbox7.Text

is the easy way.

Signature

Regards,
Tom Ogilvy

> Here is one I can't find any info on. In a UserForm, the user has the
> option of entering text in TextBox7 to be entered as Cell Comments.
[quoted text clipped - 5 lines]
> Thanks,
> J.O.

Reply to this Message

excelnut1954 - 24 Jan 2006 02:38 GMT

Thanks Tom. Works real well. Learned alot today. Especially since this
isn't my main job. I appreciate your simplicity, and your time.

Thanks JakeyC. The 2 lines of code seem to do the same thing, yet
they are different. A couple years, and I may learn enough to know why.

Thanks guys
J.O.

Reply to this Message

Tom Ogilvy - 24 Jan 2006 02:55 GMT

My method is an older method. The nice thing about it is it works even if a
comment already exists.

Signature

Regards,
Tom Ogilvy

> Thanks Tom. Works real well. Learned alot today. Especially since this
> isn't my main job. I appreciate your simplicity, and your time.
[quoted text clipped - 4 lines]
> Thanks guys
> J.O.

Reply to this Message