Excel Macro Visual Basic Help Needed URGENT

IN PROGRESS
Bids
7
Avg Bid (USD)
N/A
Project Budget (USD)
$30 - $250

Project Description:
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.

-=Workbook Purpose=-

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=-

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=-

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.

Thank you!

PS - Please disregard my budget, and place your bid for the price you feel is fair and reasonable.

Skills required:
Excel, Visual Basic
Additional Files: Project.xls
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.