|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
April 26th 06, 12:34 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Check Excel Comment
How do I check if a Cell has a comment field in VBA before I try and ADD a
comment? e.g. if Cells(A,1).Comment = "1" Cells(A,1).Comment.Delete Else Cells(A,1).AddComment Cells(A,1).Comment.Text("My Text") 
|
|
#2
April 26th 06, 06:27 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Check Excel Comment
Am Tue, 25 Apr 2006 15:34:01 -0700 schrieb Bob Smith:
Bob, I´m sure you´d get an answer in an Excel related group, e.g. in: microsoft.public.excel.programing -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.vbOffice.net -- How do I check if a Cell has a comment field in VBA before I try and ADD a comment? e.g. if Cells(A,1).Comment = "1" Cells(A,1).Comment.Delete Else Cells(A,1).AddComment Cells(A,1).Comment.Text("My Text")
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| comment | eduardo vladimir | Outlook Express | 0 | February 17th 06 06:08 AM |
| allo comment ca va | [email protected] | Outlook Express | 1 | February 10th 06 05:29 PM |
| William Kennedy comment | Concerned reseller | Outlook - Installation | 1 | January 24th 06 12:26 AM |
| Not Q. but comment on OE "server not working" | Steve Cochran | Outlook Express | 1 | January 10th 06 07:52 PM |
| Pls comment my VBS | Tony WONG | Outlook and VBA | 1 | January 10th 06 04:34 PM |
Hybrid Mode
