Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Comment
I want to insert a comment in an active cell that shows the username and the word "ordered". I want the comment to be on two lines as shown: username ORDERED Thanks, Larry |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Comment
Hi Larry,
I created this in XL2003: Sub AddComment() On Local Error Resume Next ActiveCell.AddComment ActiveCell.Comment.Text _ Text:=Application.UserName & _ vbNewLine & "ORDERED" End Sub HTH, Wouter |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Comment
Sub Macro1() With ActiveCell .AddComment .Comment.Visible = False .Comment.Text Text:=Application.UserName & Chr(10) & "ORDERED" End With End Sub -- Gary''s Student - gsnu200819 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Comment
Thanks Gary. Works perfectly. "Gary''s Student" wrote: Sub Macro1() With ActiveCell .AddComment .Comment.Visible = False .Comment.Text Text:=Application.UserName & Chr(10) & "ORDERED" End With End Sub -- Gary''s Student - gsnu200819 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Comment | Excel Discussion (Misc queries) | |||
Insert Comment | Excel Discussion (Misc queries) | |||
Insert Comment | Excel Discussion (Misc queries) | |||
Insert Comment | Excel Discussion (Misc queries) | |||
How do I insert a comment when the Insert:Comment menu is greyed? | Excel Discussion (Misc queries) |