-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
cmttext
-
J
Protected Worksheet BeforeDoubleClick Event Cancel=True Allowing Cell Contents to be Edited
I have the following code in place to put in a comment when you double-click in the cell. The code seems to work fine; however, when I then click in the cell (after inserting a comment) and then up in the formula bar, the text goes away leaving the comment. Wondering if anyone can tell me why...- jhedges
- Thread
- cmttext dim long string text
- Replies: 3
- Forum: Excel Questions
-
J
Compile Error on Previously Working Code
Team, I adopted the following code from the forum and it has been working for years now, until recently in one workbook. The code also works fine in other workbooks. In the workbook in question I get a Compile Error Invalid number of Arguments or Invalid Property Assignment and it highlights...- jhedges
- Thread
- cmttext code dim end long
- Replies: 5
- Forum: Excel Questions
-
J
Insert Cell Comment with a VBA Before_DoubleClick event Question
I have adopted the following code from this site I believe; however, not sure who to give credit to at the moment. My problem is when I already have a cell with a comment inserted by this macro and want to add an additional comment to the same cell it doesn't work correctly in my opinion. If I...- jhedges
- Thread
- cmttext comment dim long string
- Replies: 2
- Forum: Excel Questions
