| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comments
I would like the user to be taken to a new comment, or the existing one, of
the currently selected cell. I can get a new comment inserted With Selection .AddComment .Comment.Visible = False .Comment.Text Text:="" End With but I can't get the cursor to end up inside the comment, awaiting the user's input. Any ideas? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comments
There's some sample code for inserting or editing comments he
http://www.contextures.com/xlcomments03.html#Plain Christopher Weaver wrote: I would like the user to be taken to a new comment, or the existing one, of the currently selected cell. I can get a new comment inserted With Selection .AddComment .Comment.Visible = False .Comment.Text Text:="" End With but I can't get the cursor to end up inside the comment, awaiting the user's input. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comments
Thank you, that's exactly what I was looking for.
BTW, what does "%ie~" refer to in the SendKeys? "Debra Dalgleish" wrote in message ... There's some sample code for inserting or editing comments he http://www.contextures.com/xlcomments03.html#Plain Christopher Weaver wrote: I would like the user to be taken to a new comment, or the existing one, of the currently selected cell. I can get a new comment inserted With Selection .AddComment .Comment.Visible = False .Comment.Text Text:="" End With but I can't get the cursor to end up inside the comment, awaiting the user's input. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comments
The % represents the Alt key, so Alt+i opens the Insert menu
On the Insert menu, the e in Edit Comment is underlined, so that command is selected when the e is sent. Christopher Weaver wrote: Thank you, that's exactly what I was looking for. BTW, what does "%ie~" refer to in the SendKeys? "Debra Dalgleish" wrote in message ... There's some sample code for inserting or editing comments he http://www.contextures.com/xlcomments03.html#Plain Christopher Weaver wrote: I would like the user to be taken to a new comment, or the existing one, of the currently selected cell. I can get a new comment inserted With Selection .AddComment .Comment.Visible = False .Comment.Text Text:="" End With but I can't get the cursor to end up inside the comment, awaiting the user's input. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comments
Would an InputBox work for you?
(This does not use a Set variable) Sub Demo() With ActiveCell If .Comment Is Nothing Then .AddComment InputBox("Enter text for Comment") .Comment.Shape.TextFrame.AutoSize = True End If End With End Sub -- Dana DeLouis Using Windows XP & Office XP = = = = = = = = = = = = = = = = = "Christopher Weaver" wrote in message ... Thank you, that's exactly what I was looking for. BTW, what does "%ie~" refer to in the SendKeys? "Debra Dalgleish" wrote in message ... There's some sample code for inserting or editing comments he http://www.contextures.com/xlcomments03.html#Plain Christopher Weaver wrote: I would like the user to be taken to a new comment, or the existing one, of the currently selected cell. I can get a new comment inserted With Selection .AddComment .Comment.Visible = False .Comment.Text Text:="" End With but I can't get the cursor to end up inside the comment, awaiting the user's input. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comments
This is great! Got a dialog box with a larger input window?
"Dana DeLouis" wrote in message ... Would an InputBox work for you? (This does not use a Set variable) Sub Demo() With ActiveCell If .Comment Is Nothing Then .AddComment InputBox("Enter text for Comment") .Comment.Shape.TextFrame.AutoSize = True End If End With End Sub -- Dana DeLouis Using Windows XP & Office XP = = = = = = = = = = = = = = = = = "Christopher Weaver" wrote in message ... Thank you, that's exactly what I was looking for. BTW, what does "%ie~" refer to in the SendKeys? "Debra Dalgleish" wrote in message ... There's some sample code for inserting or editing comments he http://www.contextures.com/xlcomments03.html#Plain Christopher Weaver wrote: I would like the user to be taken to a new comment, or the existing one, of the currently selected cell. I can get a new comment inserted With Selection .AddComment .Comment.Visible = False .Comment.Text Text:="" End With but I can't get the cursor to end up inside the comment, awaiting the user's input. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comments
Thank you again. This is very valuable information. As you can see, I'm
really new at this. I'm finding the help text not well organized for my purposes. I hope you all will tolerate my questions. "Debra Dalgleish" wrote in message ... The % represents the Alt key, so Alt+i opens the Insert menu On the Insert menu, the e in Edit Comment is underlined, so that command is selected when the e is sent. Christopher Weaver wrote: Thank you, that's exactly what I was looking for. BTW, what does "%ie~" refer to in the SendKeys? "Debra Dalgleish" wrote in message ... There's some sample code for inserting or editing comments he http://www.contextures.com/xlcomments03.html#Plain Christopher Weaver wrote: I would like the user to be taken to a new comment, or the existing one, of the currently selected cell. I can get a new comment inserted With Selection .AddComment .Comment.Visible = False .Comment.Text Text:="" End With but I can't get the cursor to end up inside the comment, awaiting the user's input. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comments
OK, this is the kind of thing that makes me nuts! It worked, really it did,
and now it doesn't. The part that's failing, oddly, is the part that I didn't understand in the first place: SendKeys "%ie~". The comment is created but never does the edit comment happen. Any ideas on this? "Debra Dalgleish" wrote in message ... The % represents the Alt key, so Alt+i opens the Insert menu On the Insert menu, the e in Edit Comment is underlined, so that command is selected when the e is sent. Christopher Weaver wrote: Thank you, that's exactly what I was looking for. BTW, what does "%ie~" refer to in the SendKeys? "Debra Dalgleish" wrote in message ... There's some sample code for inserting or editing comments he http://www.contextures.com/xlcomments03.html#Plain Christopher Weaver wrote: I would like the user to be taken to a new comment, or the existing one, of the currently selected cell. I can get a new comment inserted With Selection .AddComment .Comment.Visible = False .Comment.Text Text:="" End With but I can't get the cursor to end up inside the comment, awaiting the user's input. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Comments
A correction to my most recent post within this branch of this thread:
This code works fine when invoke through Alt-F8, etc. It fails when I invoke it with a CTRL-key shortcut key that I defined in the Options dialog box within the macros dialog box. "Debra Dalgleish" wrote in message ... The % represents the Alt key, so Alt+i opens the Insert menu On the Insert menu, the e in Edit Comment is underlined, so that command is selected when the e is sent. Christopher Weaver wrote: Thank you, that's exactly what I was looking for. BTW, what does "%ie~" refer to in the SendKeys? "Debra Dalgleish" wrote in message ... There's some sample code for inserting or editing comments he http://www.contextures.com/xlcomments03.html#Plain Christopher Weaver wrote: I would like the user to be taken to a new comment, or the existing one, of the currently selected cell. I can get a new comment inserted With Selection .AddComment .Comment.Visible = False .Comment.Text Text:="" End With but I can't get the cursor to end up inside the comment, awaiting the user's input. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
| Comments box | Excel Discussion (Misc queries) | |||
| in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
| Comments. | New Users to Excel | |||
| Comments | Excel Discussion (Misc queries) | |||
Linear Mode
