I need help revising some Visual Basic code in an Excel macro to make it work the way we need it to work. I've been stumped a while on this - hopefully someone can help.
I have a workbook (attached) where when I double-click on a cell, a pop-up box will appear allowing me to add a comment to the cell. This new comment would be added to whatever comments were already in that cell. In addition, the date, time, Excel registration name, etc. are all appended to the new comment (this function serves as a way to keep track of things). The following are descriptions of the two main issues we are having
Issue 1: I am having an issue where if I make any edits to a comment (right click the cell and edit comment) and apply new formatting (bolding, underlining, etc.), all this comment formatting is lost after I input a new comment (by double-clicking the cell and entering the new comment). Basically, I could have spent a few hours applying strike-through, bold, italics, etc. to comments only to have my work lost when a new comment is entered into the cell (all the comment text defaults back to regular text formatting).
Issue 2: This workbook is typically shared between many users (shared mode enabled). When I want to edit a comment, I can not type directly into the comment to make any changes. Thus, the traditional way of right clicking a commented cell and clicking the "edit comment" button does not provide too much functionality. To delete things, I have to highlight the comment text and cut it out and to type things in I type the comments I wish to add in Notepad and then copy and paste the text into the comment. This is a very round-about way to make edits, but it is the only way I know how with the macro we are using.
-=PLEASE READ BEFORE BIDDING=-
In your bid please respond with "Issue 1 solve" if you can only solve issue 1, "Issue 2 solve" if you can only solve issue 2, or "Issue 1 & 2 solve" if you can solve both issues. I NEED AN EXTREMELY FAST turnaround so please also include when you expected turnaround time would be.
PS - Please disregard my budget, and place your bid for the price you feel is fair and reasonable.