VBA code for a comment tracker on a userform

[chin67326]

Hello. Can you please help me find a way to track comments in the attached file?

There is a button to enter a comment and button to view comments.

- Ideally I would like to view the comments in the sequence they were entered.
- Do you think a listbox is a good way to view them? What clever ideas do you have to display the sequence of comments?
- It would be nice to not have the comments clipped as list boxes tend to clip text as row space is limited. Can we wrap text so rows in the listbox show all the comments?
- Is a listbox advised or do you have a better recommendation?
- For the purpose of this you can save the data on a sheet on the attached however I would be saving the data in a sheet on another workbook, so if you can provide some guidance on how to write the data to another filepath, that would be great.
- Next to each comment I would like a username, date and time stamp - therefore you can add the below code to your solution

Environ$("Username") & " - " & Now()

The below is an example of something I am looking for. Maybe instead of a listbox, the comment log can be viewed on a large textbox [the size of a userform] with a grey background and scroll bars to view all past comments?

Sample 2 of comment tracker.JPG

Please let me know what smart, cool ideas you have for a comment tracker!

Thanks.

[chin67326]

Deadline for this project approaching, please help whoever can.

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[chin67326]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

I posted elsewhere as I thought no one here replied because they did not know the solution. Normally folks here are knowledgeable you see and they failed me.

[6StringJazzer]

There is no problem with posting somewhere else. If you do, we require a link so that you not have people wasting effort to solve a problem in one place that is already solved in another.

I am guessing that the reason you have not had a response is that you are not asking a targeted question to get over a sticking point, you are asking someone to develop an entire solution to an overall problem from virtually nothing. Your file has only two buttons and a couple of simple forms. You are basically asking someone to donate an hour or more of their time so you can meet your deadline. There is probably a similar take on this at MrExcel--I note that the only response there is very general guidance, which you did not acknowledge.

Folks here did not fail you. It seems that you failed to start your project sufficiently in advance of your deadline.

[scottiex]

chin67326,
FWIW, your not posting links compounded the fact that there was not time to find the not insignificant amount of spare time it would take to do the job because you got the thread 'locked'.