Writing UserForm Information to a Cell Comment

[Maverick99]

For a particular project, when a user logs in, a UserForm will appear for input on what procedures are needed from the Lab.

The UserForm (frmInputProc) has 11 Check Boxes and a Text Box for Special Instructions. When the "Save Data" commandbutton is clicked, I would like Label from each checkbox that has been selected, entered into a Comment Field, to a Table (2007) cell, followed by the Special Instructions typed into the TextBox.<o></o>
<o> </o>
This needs to be placed in column N, on the last row of the Table, in Worksheet "Log". Once the Save Data Button is pushed, the cell comment would look something like below.

Procedures to be performed:
1. Checkbox 1 Label or " --- Checkbox 1 Label" (having it numbered is not critical)
2. Checkbox 3 Label
3. Checkbox 6 Label

Special Instructions:
Information from Textbox1

There is a unique ID number for each row (Col C). The same is true for the last row, which should be empty. There should not be an issue with overwriting a comment, in theory the comment is written to only once. However, if there should be a problem with the code and it didn’t increment the row, then is there a way to just append what is there? If not, that’s okay, I would need to find out why Col N on the last row had a comment in it.<o></o>

What would be the best way to accomplish this?


Thanks Community,


Maverick