| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set a comment in a cell with VBA?
I should have thought that the command:
range("A1").comment = "This is a comment in cell A1" would work ... but it doesn't. I get an error message which reads: "Object variable or With block variable not set" Can anyone help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set a comment in a cell with VBA?
Record a macro while doing it manually, read it afterwards, and you will see
the light. Or at least something on a bright white background. HTH. Best wishes Harald "Pete at Sappi Fine Paper" skrev i melding ... I should have thought that the command: range("A1").comment = "This is a comment in cell A1" would work ... but it doesn't. I get an error message which reads: "Object variable or With block variable not set" Can anyone help? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set a comment in a cell with VBA?
Thanks Harald, but I tried that and it didn't work. Even copied the macro
and pasted it into my program. Same error. "Harald Staff" wrote: Record a macro while doing it manually, read it afterwards, and you will see the light. Or at least something on a bright white background. HTH. Best wishes Harald "Pete at Sappi Fine Paper" skrev i melding ... I should have thought that the command: range("A1").comment = "This is a comment in cell A1" would work ... but it doesn't. I get an error message which reads: "Object variable or With block variable not set" Can anyone help? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set a comment in a cell with VBA?
Easiest is:
range("A1").notetext text:="This is a comment in cell A1" -- Regards, Tom Ogilvy "Pete at Sappi Fine Paper" wrote in message ... I should have thought that the command: range("A1").comment = "This is a comment in cell A1" would work ... but it doesn't. I get an error message which reads: "Object variable or With block variable not set" Can anyone help? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set a comment in a cell with VBA?
Thanks Tom! That worked!
"notetext" instead of "comment" ... now THAT'S intuitive.... *grumble grumble* "Tom Ogilvy" wrote: Easiest is: range("A1").notetext text:="This is a comment in cell A1" -- Regards, Tom Ogilvy "Pete at Sappi Fine Paper" wrote in message ... I should have thought that the command: range("A1").comment = "This is a comment in cell A1" would work ... but it doesn't. I get an error message which reads: "Object variable or With block variable not set" Can anyone help? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set a comment in a cell with VBA?
Hi Pete,
"notetext" instead of "comment" ... now THAT'S intuitive.... *grumble grumble* See Tom's earlier post: http://tinyurl.com/77a7l --- Regards, Norman "Pete at Sappi Fine Paper" wrote in message ... Thanks Tom! That worked! "notetext" instead of "comment" ... now THAT'S intuitive.... *grumble grumble* "Tom Ogilvy" wrote: Easiest is: range("A1").notetext text:="This is a comment in cell A1" -- Regards, Tom Ogilvy |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set a comment in a cell with VBA?
Hi Pete,
For an existing comment try: Range("A1").Comment.Text _ "This is a comment in cell A1" or to create the comment: With ActiveSheet.Range("A1").AddComment .Text "Howdy!" End With --- Regards, Norman "Pete at Sappi Fine Paper" wrote in message ... I should have thought that the command: range("A1").comment = "This is a comment in cell A1" would work ... but it doesn't. I get an error message which reads: "Object variable or With block variable not set" Can anyone help? |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I set a comment in a cell with VBA?
Thanks Norman. I'll bear this in mind, but Tom's solution worked so I'm
sticking with that for the moment. "Norman Jones" wrote: Hi Pete, For an existing comment try: Range("A1").Comment.Text _ "This is a comment in cell A1" or to create the comment: With ActiveSheet.Range("A1").AddComment .Text "Howdy!" End With --- Regards, Norman "Pete at Sappi Fine Paper" wrote in message ... I should have thought that the command: range("A1").comment = "This is a comment in cell A1" would work ... but it doesn't. I get an error message which reads: "Object variable or With block variable not set" Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can insert digital ink into Excel cell or a cell comment? | Excel Discussion (Misc queries) | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| Create Cell Comment based on text in a cell on another worksheet | Excel Discussion (Misc queries) | |||
| I want to change comment printing cell 3 to whats in cell 3 | Excel Worksheet Functions | |||
| a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions | |||
Hybrid Mode
