Posted to microsoft.public.excel.programming

Gman

external usenet poster

Posts: 18

Code to see if Comment Exists

Neater! Why didn't I think of that....

Dana DeLouis wrote:
Just some more options:

Sub Demo()
With ActiveCell
If .Comment Is Nothing Then
.AddComment "First Line" & vbLf
Else
.Comment.Text .Comment.Text & "More Lines" & vbLf
End If
.Comment.Shape.TextFrame.AutoSize = True
End With
End Sub

HTH :)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA code to check if a custom chart exists	shoba[_3_]	Excel Programming	0	August 4th 05 02:12 PM
Worksheets Exists Code...	KimberlyC	Excel Programming	3	July 7th 05 09:19 PM
Code to delete all comment boxes	Shawn	Excel Discussion (Misc queries)	1	June 2nd 05 03:21 PM
VB Code to size the comment box	SUNIL PATEL	Excel Programming	1	July 1st 04 09:26 PM
Help with code that checks if a sheet exists	wachen	Excel Programming	2	February 10th 04 02:39 AM

All times are GMT +1. The time now is 07:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us