|
Code for opening Comment box
Hello, Does anyone know what code would automatically bring up a comment bo when the word "JOINT" is typed in that cell? I already have the I statement, but I don't know the code to open a comment box. Thanks, Chir -- chris4652 ----------------------------------------------------------------------- chris46521's Profile: http://www.excelforum.com/member.php...fo&userid=3590 View this thread: http://www.excelforum.com/showthread.php?threadid=56161 |
Code for opening Comment box
MyRange.AddComment
MyRange.Comment.Visible = False 'Or True MyRange.Comment.Text Text:="your comment here." Where MyRange is the range of your cell. Mike "chris46521" wrote: Hello, Does anyone know what code would automatically bring up a comment box when the word "JOINT" is typed in that cell? I already have the If statement, but I don't know the code to open a comment box. Thanks, Chirs -- chris46521 ------------------------------------------------------------------------ chris46521's Profile: http://www.excelforum.com/member.php...o&userid=35909 View this thread: http://www.excelforum.com/showthread...hreadid=561618 |
Code for opening Comment box
Thanks Mike! That works great. Do you know if there is a way to have the comment box open up with the cursor flashing after some bold text? I would also like the box close again after the user has finished inputting the data. Thanks! Chris crazybass2 Wrote: MyRange.AddComment MyRange.Comment.Visible = False 'Or True MyRange.Comment.Text Text:="your comment here." Where MyRange is the range of your cell. Mike "chris46521" wrote: Hello, Does anyone know what code would automatically bring up a comment box when the word "JOINT" is typed in that cell? I already have the If statement, but I don't know the code to open a comment box. Thanks, Chirs -- chris46521 ------------------------------------------------------------------------ chris46521's Profile: http://www.excelforum.com/member.php...o&userid=35909 View this thread: http://www.excelforum.com/showthread...hreadid=561618 -- chris46521 ------------------------------------------------------------------------ chris46521's Profile: http://www.excelforum.com/member.php...o&userid=35909 View this thread: http://www.excelforum.com/showthread...hreadid=561618 |
Code for opening Comment box
Chris,
Not sure about the bold text, but this will create a comment, make it visible, add some text, and then leave it open for the use to make additions to the text. MyRange.AddComment MyRange.Comment.Visible = True MyRange.Comment.Text Text:="your text" & Chr(10) MyRange.Comment.Shape.Select True Mike "chris46521" wrote: Thanks Mike! That works great. Do you know if there is a way to have the comment box open up with the cursor flashing after some bold text? I would also like the box close again after the user has finished inputting the data. Thanks! Chris crazybass2 Wrote: MyRange.AddComment MyRange.Comment.Visible = False 'Or True MyRange.Comment.Text Text:="your comment here." Where MyRange is the range of your cell. Mike "chris46521" wrote: Hello, Does anyone know what code would automatically bring up a comment box when the word "JOINT" is typed in that cell? I already have the If statement, but I don't know the code to open a comment box. Thanks, Chirs -- chris46521 ------------------------------------------------------------------------ chris46521's Profile: http://www.excelforum.com/member.php...o&userid=35909 View this thread: http://www.excelforum.com/showthread...hreadid=561618 -- chris46521 ------------------------------------------------------------------------ chris46521's Profile: http://www.excelforum.com/member.php...o&userid=35909 View this thread: http://www.excelforum.com/showthread...hreadid=561618 |
Code for opening Comment box
Perfect! Thanks! crazybass2 Wrote: Chris, Not sure about the bold text, but this will create a comment, make it visible, add some text, and then leave it open for the use to mak additions to the text. MyRange.AddComment MyRange.Comment.Visible = True MyRange.Comment.Text Text:="your text" & Chr(10) MyRange.Comment.Shape.Select True Mike "chris46521" wrote: Thanks Mike! That works great. Do you know if there is a way to hav the comment box open up with the cursor flashing after some bold text? I would also like the box close again after the user has finished inputting the data. Thanks! Chris crazybass2 Wrote: MyRange.AddComment MyRange.Comment.Visible = False 'Or True MyRange.Comment.Text Text:="your comment here." Where MyRange is the range of your cell. Mike "chris46521" wrote: Hello, Does anyone know what code would automatically bring up comment box when the word "JOINT" is typed in that cell? I already have th If statement, but I don't know the code to open a comment box. Thanks, Chirs -- chris46521 ------------------------------------------------------------------------ chris46521's Profile: http://www.excelforum.com/member.php...o&userid=35909 View this thread: http://www.excelforum.com/showthread...hreadid=561618 -- chris46521 ------------------------------------------------------------------------ chris46521's Profile http://www.excelforum.com/member.php...o&userid=35909 View this thread http://www.excelforum.com/showthread...hreadid=561618 -- chris4652 ----------------------------------------------------------------------- chris46521's Profile: http://www.excelforum.com/member.php...fo&userid=3590 View this thread: http://www.excelforum.com/showthread.php?threadid=56161 |
| All times are GMT +1. The time now is 07:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com