Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert repeat comments
I need to create macros that will enable me to insert repeat comments boxes
in multiple cells. There are a number of different comments boxes I'll need, all single words: Spanish French Italian etc Any advice on how to do this much appreciated, I've never used macros before. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert repeat comments
To show you how far I've got so far. I've tried to record manually and have
the following: Sub French() 'adds French comment ActiveCell.AddComment Text:="French" Set cmt = ActiveCell.Comment With cmt.Shape.TextFrame.Characters.Font .Name = "Times New Roman" .Size = 8 .Bold = False .ColorIndex = 0 End With SendKeys "%ie~" End Sub But get an error message that says "can't execute code in break mode". "claraloupot" wrote: I need to create macros that will enable me to insert repeat comments boxes in multiple cells. There are a number of different comments boxes I'll need, all single words: Spanish French Italian etc Any advice on how to do this much appreciated, I've never used macros before. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert repeat comments
It worked OK for me. I got a comment dropdown box that has the word French
in it. "claraloupot" wrote: To show you how far I've got so far. I've tried to record manually and have the following: Sub French() 'adds French comment ActiveCell.AddComment Text:="French" Set cmt = ActiveCell.Comment With cmt.Shape.TextFrame.Characters.Font .Name = "Times New Roman" .Size = 8 .Bold = False .ColorIndex = 0 End With SendKeys "%ie~" End Sub But get an error message that says "can't execute code in break mode". "claraloupot" wrote: I need to create macros that will enable me to insert repeat comments boxes in multiple cells. There are a number of different comments boxes I'll need, all single words: Spanish French Italian etc Any advice on how to do this much appreciated, I've never used macros before. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert a quote mark, then repeat | Excel Programming | |||
How do I repeat an ellipsis without going into Insert/Symbol, etc | New Users to Excel | |||
macro to insert comments? | Excel Discussion (Misc queries) | |||
How do I insert Sunday,Monday,Tuesday, etc. to repeat in nonadjac. | Excel Worksheet Functions | |||
Simple (?) Macro Assistance- Select, Insert, Paste, Rinse, Repeat | Excel Programming |